Cycle all controls on all objects?

[ptg]

Hi to all, I'm sure I've seen something somewhere, but google isn't being my friend..

I'm in the middle of writing a multi-language procedure, and in order to populate the label database I would like to cycle all forms (regardless of whether they're open or closed) and cycle all controls within the forms. If anyone has a link to code to do this, it would be greatly appreciated - I've seen a good start somewhere over the last few weeks, but forgotten to bookmark it

Thanks in advance

 

[Galaxiom]

Loop through the CurrentProject.AllForms collection, open the form if the IsLoaded property is False.
Loop through the controls collection of the opened form.

 

[ChrisO]

Can you please describe in more detail why you think you need to do this “regardless of whether they're open or closed”?

If you are talking about changing the natural language, such as English or German, that a database displays in Label Controls then it would normally be done while each Form/Report is opening for the end user but before it is displayed.

Chris.

 

[ptg]

Galaxiom, Thanks for that - worked a treat