Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
easiest way to create gridlines in an Access 2003 report
31 views
Skip to first unread message
Liam0364
Jun 6, 2010, 9:58:45 PM6/6/10
to
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?
that it resembles a spreadsheet, other than manually drawing vertical and
horizontal lines?
Allen Browne
Jun 7, 2010, 2:39:35 AM6/7/10
to
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
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" <Liam...@discussions.microsoft.com> wrote in message
news:04B0BCD3-ED07-4A9E...@microsoft.com...
0 new messages