Changing fotn of all database objects in onw foul swoop

[tezread]

Is there a way to change the font size and type of all database objects - forms (including labels, text boxes etc), queries etc so they are ALL the same

 

[gemma-the-husky]

i have written code to do this - not sure if it can be done any other way, with later versions of access

you basically need code to open every form (say) in design mode, and then iterate all the controls etc, and set details as you require, and then save the changed design. Offhand you need to iterate the forms container collection.

you could probably achieve a similar thing at run time, in each forms open event - depends how quick it would run. That way you could let your users "design" their own look and feel

 

[vbaInet]

Plus you may need to take into account the extra width or height that would be required to accomodate a bigger font. Not just the control but also the inner width and height of the sections where the controls are placed. Maybe just set the inner width and height (of the sections) to the max so you don't have to worry about that.

I would suggest you limit the users to a limited list of font sizes, say 10 to 14. You would also need to choose a sensible font type as well.

For reports I would suggest you simply allow users to use the built-in zoom. Or here's another way:

http://www.mvps.org/access/reports/rpt0020.htm

I'm sure you've figured out already that it's not going to be easy!

You might just be better off looking into purchasing a form resizer for access forms.