Get Control Type.

[Ed2020]

Is there a VB function that returns the control type?

Ed Metcalfe.

 

[TheWildHare]

Yes. Check out the CONTROLS collection. You can enumerate all the controls within an object, and by setting s variable of type CONTROL, examine it's properties such as type, name, value, etc etc..

 

[Ed2020]

I'm perhaps missing something obvious but as far as I can see a Control type object variable does not have a .Type property.........

Ed Metcalfe.

 

[WildHare]

Sorry, yes, it's the CONTROLTYPE property...

Jim Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com

 

[Ed2020]

Hmmmm...... thanks for that, but why isn't ControlType in the list of properties for the object variable?? It works, but how are you supposed to find it if it ain't listed??

Ed Metcalfe.

 

[WildHare]

Hmmmm back..there's a full page in the Help system on CONTROLTYPE, including an example that iterates through all the controls on a form and changes some of their properties.

To return the TYPE of a control, you should be able to just query it:

Dim f as form, c as control, t as string

set f = Forms!MyForm
Set c = f.TxtName

t = c.Controltype

"t" would now be set to "acTextBox"

Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com