Changing Default Font Style in Reports

[hmross]

I am tierd of changing individual properties and would like to understand how to change the default font used in the Access 2007 Reports. I know I can use an existing report file like as a template. What I want is to create a new report from the default Access Report Template and have the default font style for all objects placed in the report to be of my choosing. Is that asking to much? Ponting me to other threads or posts will be fine. This can not be a new subject.

 

[llkhoutx]

Cycle through the forms control container and change the font of all controls, e.g.

dim ctl as control
for each ctl in me.controls
me(ctl.name).font=... (whatever)
next ctl

 

[hmross]

Thanks for the reply--not sure I understand the loaction of the change you suggested.

 

[vbaInet]

There's no property for setting this. Click anywhere inside your report, hold down Ctrl + A to select all objects and change the font. That's as easy as it would get.

 

[hmross]

Ok, thanks for the lesson--Control-"A" to select all objects. This will likely work for me. I was hoping to be able to change the default properties of the file used by Access when launching "create a report". This seems reasonable in Today's software arena.

 

[vbaInet]

This seems reasonable in Today's software arena.

Yes, but Access is a database with more focus on the data side than look-and-feel. There aren't many dbs out there that come packaged with a UI builder so I can understand why they haven't put in all those extra features.

It might be possible in Access 2010 though... I'm not sure.

 

[llkhoutx]

VBaInet is incorrect. The font property of all controls in a report can be changed programmatically. See this site

 

[vbaInet]

VBaInet is incorrect. The font property of all controls in a report can be changed programmatically. See this site

Please point me to the post where I explicitly mentioned that the Font properties cannot be changed in code? Also, please read the OP.