Prev: conditional numeric formatting of field output on report
Next: PageSetup properties keep changing
From: Liam0364 on 6 Jun 2010 21:58
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?
From: Allen Browne on 7 Jun 2010 02:39
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(a)discussions.microsoft.com> wrote in message
news:04B0BCD3-ED07-4A9E-A6FB-BD9F6A1815FC(a)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?

 | 
Pages: 1
Prev: conditional numeric formatting of field output on report
Next: PageSetup properties keep changing