Quick way to get all control names in a form ??

[Guest]

Is there any quick way to see all the control names on a form so I know what names to refer to in my VBA code, rather than going into 'properties' for each one?

 

[Dirk Goldgar]

Is there any quick way to see all the control names on a form so I
know what names to refer to in my VBA code, rather than going into
'properties' for each one?

If the form is open in design view, the "object box" at the left-hand
end of the form design toolbar contains a dropdown list of all objects
on the form. Or, for a quick list, open the form, whether in design
view or otherwise, then press Ctrl+G to open the Immediate window, and
type the line of code below into that window and press Enter:

for each c in Forms!YourFormName : ?c.name : next c

(substitute your form's name for "YourFormName" in the above line.)