Control properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I loop through all controls on a form and write the properties to a
..txt file?

Ronny
 
Simplest solution would be to use the undocumented SaveAsText:
SaveAsText acForm, "Form1", "C:\Form1.txt"

Next simplest would be to use the built in documenter, and export it:
Tools | Analyze | Documenter

What you were probably expecting was to loop through the AllForms collection
(Access 2000 and later), to get the name of each AccessObject. Then
OpenForm, in design view, hidden, and loop through the Controls of the Form.
For each control, loop through the Properties of the control. Use error
handling because some properties (such as Value) will not be available at
design time. To export these to a text file, see the Open statement in VBA
help.

The first option is a much simpler way to achieve the result, though.
 
Back
Top