ControlType can someone link me to the list

[sparks]

I was doing this on a form to use a keydown event

If ActiveControl.ControlType = acComboBox Then

Well for some reason in a different database it would not work.
It must have been a library or someting because when I replaced it
with this

If ActiveControl.ControlType = 107 Then

it worked fine.

I found this list of codes for the control types and now I can't find
it anywhere.

can someone tell me where the list might be found...I would have sworn
I found it in the access help but not any more.

Internet maybe?

thanks for any help

[Allen Browne]

In Access, press Ctrl+G to get you into the code window.
Then press F2 to open the Object Browser
Search for:
acComboBox

It shows you all the members of acControlType

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sparks" <js******@swbell.netwrote in message
news:3h********************************@4ax.com...

>I was doing this on a form to use a keydown event

If ActiveControl.ControlType = acComboBox Then

Well for some reason in a different database it would not work.
It must have been a library or someting because when I replaced it
with this

If ActiveControl.ControlType = 107 Then

it worked fine.

I found this list of codes for the control types and now I can't find
it anywhere.

can someone tell me where the list might be found...I would have sworn
I found it in the access help but not any more.

Internet maybe?

thanks for any help

[sparks]

Thanks but I was looking for the list of codes.
acComboBox = 107
there is a full list somewhere but I can't find it.
On Thu, 2 Aug 2007 23:08:14 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

>acComboBox

[Allen Browne]

The object browser does show the values (one by one.)

There's a list here if you prefer:
http://allenbrowne.com/ser-73.html#ControlTypeName

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sparks" <js******@swbell.netwrote in message
news:q8********************************@4ax.com...

Thanks but I was looking for the list of codes.
acComboBox = 107
there is a full list somewhere but I can't find it.
On Thu, 2 Aug 2007 23:08:14 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

>>acComboBox

[sparks]

Found it

AcControlType

Constant Value
acBoundObjectFrame 108
acCheckBox 106
acComboBox 111
acCommandButton 104
acCustomControl 119
acImage 103
acLabel 100
acLine 102
acListBox 110
acObjectFrame 114
acOptionButton 105
acOptionGroup 107
acPage 124
acPageBreak 118
acRectangle 101
acSubform 112
acTabCtl 123
acTextBox 109
acToggleButton 122

I can not understand why one time I will use ControlType = acComboBox
and everything is fine. Then one day ControlType = acComboBox

Access will scream whats an acComboBox....NEVER HEARD OF IT
change it to ControlType =111 and it works.

On Thu, 02 Aug 2007 15:05:57 GMT, sparks <js******@swbell.netwrote:

>I was doing this on a form to use a keydown event

If ActiveControl.ControlType = acComboBox Then

Well for some reason in a different database it would not work.
It must have been a library or someting because when I replaced it
with this

If ActiveControl.ControlType = 107 Then

it worked fine.

I found this list of codes for the control types and now I can't find
it anywhere.

can someone tell me where the list might be found...I would have sworn
I found it in the access help but not any more.

Internet maybe?

thanks for any help