Access 2003 Form Grid

[BlakeK]

Hi all, hopefully a simple question here:

Just upgraded from Office 2000 to Office 2003.
First thing I noticed in Access was that the grid in form design mode is very close together.
Looked up how to change it in Help, and found the Grid X and Grid Y settings in the Form property sheet.
But this only changes it for a given form.
As far as I remember, once I set this in Access 2000, it was a global setting.
How to I set the grid spacing for ALL forms, reports, etc.?
It would really suck to have to change it for the current 200+ forms and reports, and then have to change it everytime I create a new form or report. Please tell me MS didn't screw this up!

Thanks all.

 

[scking]

First, Grid X and Grid Y were never a global setting. As I understand it you have a legacy application which contains numerous grids that have properties that don't really display properly in Access 2003.

Here is what I would do. Write a short procedure to read all forms, looking for the grid control, and set their values programmatically. That would fix all the legacy forms. Second; change the default Grid X and Grid Y properties for the control so that whenever it was used on a form it would be whatever you had set for the default. There are lots of ways to 'skin the design cat' and Microsoft generally gives us the tools to be able to do it however we wish. NOT SAYING that they do everything right.




---------------------
scking@arinc.com
---------------------