Set height of all Form Headers using VBA (1 Viewer)

[Kpaw]

I have built a database and I want to set the height of the form header on all forms using a module.

I am uncertain how to write the VBA to accomplish this task.

Thanks for any assistance

 

[CJ_London]

This link may help

http://msdn.microsoft.com/en-us/library/office/ff835642.aspx

You would need to loop through all the forms in the forms collection and use code per the link to set the height

 

[Galaxiom]

You would need to loop through all the forms in the forms collection and use code per the link to set the height

Forms only become part of the Forms Collection when they are open. A better loop would be through the CurrentProject.AllForms Collection.