K Kpaw New member Local time Today, 02:37 Joined Jul 14, 2013 Messages 6 Dec 17, 2013 #1 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
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
C CJ_London Super Moderator Staff member Local time Today, 06:37 Joined Feb 19, 2013 Messages 17,763 Dec 17, 2013 #2 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
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
G Galaxiom Super Moderator Staff member Local time Today, 17:37 Joined Jan 20, 2009 Messages 12,834 Dec 17, 2013 #3 CJ_London said: You would need to loop through all the forms in the forms collection and use code per the link to set the height Click to expand... Forms only become part of the Forms Collection when they are open. A better loop would be through the CurrentProject.AllForms Collection.
CJ_London said: You would need to loop through all the forms in the forms collection and use code per the link to set the height Click to expand... Forms only become part of the Forms Collection when they are open. A better loop would be through the CurrentProject.AllForms Collection.
