easiest way to create gridlines in an Access 2003 report

  • Follow


Does anyone know an easy way to create gridlines in an Access 2003 report so 
that it resembles a spreadsheet, other than manually drawing vertical and 
horizontal lines?
0
Reply Utf 6/7/2010 1:58:45 AM

You can use the Line method of the report in its Page event.
Use a loop to repeat at whatever grid size you want.
Measurements are in twips, where 1440 twips = 1 inch

This is how the Line method works:
Me.Line (Me.ScaleTop, Me.ScaleLeft)-(Me.ScaleTop, Me.ScaleHeight), vbRed

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Liam0364" <Liam0364@discussions.microsoft.com> wrote in message 
news:04B0BCD3-ED07-4A9E-A6FB-BD9F6A1815FC@microsoft.com...
> Does anyone know an easy way to create gridlines in an Access 2003 report 
> so
> that it resembles a spreadsheet, other than manually drawing vertical and
> horizontal lines? 

0
Reply Allen 6/7/2010 6:39:35 AM


1 Replies
591 Views

(page loaded in 0.051 seconds)

Similiar Articles:
















7/24/2012 2:44:15 PM


Reply: