Formatting in Runtime

[Guest]

I have a runtime application (mde) which includes an report invoice. My
user would like to change the font on this report. Can I give them the
ability to do this? If so how?

Thanks

 

[Allen Browne]

You could use the Open event of the report to loop through its Controls
collection, and set the FontName property of each appropriate control.

To get a list of available fonts, see:
Enumerating System Fonts
at:
http://www.mvps.org/access/api/api0033.htm

Naturally there could be some issues with the size of the controls, as the
metrics vary between fonts. There is an example based on calculating font
sizes at:
http://www.lebans.com/autosizefont.htm