Determing What Kind of Controls When Enumerating Controls on a For

[Mr. JYC]

Hi

Could someone tell me how to determine what type of controls are on a form
when it is enumerated using the class Controls and for each...in, next.

How do we determine also if the control is either a tab control or option
group control as stated in the help section of MS Access.

 

[Allen Browne]

Examine the ControlType property of the control.

The value will be acTabCtl for a tab control, or acOptionGroup for an option
group.

Here's a function that returns the value as text:
http://allenbrowne.com/ser-73.html#ControlTypeName