Combo Box Using Caps Lock

[Jeannie]

Is there a setting that needs to be activated so that you can be in Caps lock
when typing in a combo box?

 

[Dirk Goldgar]

Is there a setting that needs to be activated so that you can be in Caps
lock
when typing in a combo box?

What are you trying to accomplish, exactly? A combo box presents entries in
its list that have whatever case you originally entered for them, but the
matching of those entries against what the user types is not case-sensitive,
so it doesn't matter whether the Caps Lock key is on or off, so far as the
matching is concerned. If the user's entry matches an item in the combo's
list, the value of the combo box will be capitalized according to the list
entry, as soon as the focus leaves the control.

If the combo box's Limit To List property is set to No, so you can enter
values that aren't in the list, then I can see how you might care what case
those unmatched entries are in. Is that what prompts your question?

 

[CrazyAccessProgrammer]

if you want everything in the drop-down list to be in all caps set the sql
behind the drop-down box to use the ucase function on the field that is
displayed. Say for example the field MyName is what the user sees when
clicking on the dropdown box, you would change your sql as follows:

Name: ucase([MyName])

Of course this does nothing to set the keyboard to caps lock, it just makes
everything in the drop down list in all caps.