OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Setting Up & Running Reports (http://www.officefrustration.com/forumdisplay.php?f=26)
-   -   easiest way to create gridlines in an Access 2003 report (http://www.officefrustration.com/showthread.php?t=1119822)

Liam0364 June 7th, 2010 02:58 AM

easiest way to create gridlines in an Access 2003 report
 
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?

Allen Browne June 7th, 2010 07:39 AM

easiest way to create gridlines in an Access 2003 report
 
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" wrote in message
...
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?




All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com