Change input to Combobox to UPPERCASE

[Avid Fan]

Change input to Combobox to UPPERCASE. Such a simple thing to do.

I don't know whether to attack this simple problem from the imput mask
or keypress.

Either way I seem to have forgotten how to do this.

Thanks for your help.

 

[Avid Fan]

Change input to Combobox to UPPERCASE. Such a simple thing to do.

I don't know whether to attack this simple problem from the imput mask
or keypress.

Either way I seem to have forgotten how to do this.

Thanks for your help.

Should have mentioned that >???????????? in the imput mask does not work.

 

[Avid Fan]

Should have mentioned that >???????????? in the imput mask does not work.

Forget it. It is working now. Thanks

 

[John W. Vinson]

Change input to Combobox to UPPERCASE. Such a simple thing to do.

I don't know whether to attack this simple problem from the imput mask
or keypress.

Either way I seem to have forgotten how to do this.

Thanks for your help.

Use code in the combo box's AfterUpdate event:

Private Sub comboname_AfterUpdate()
Me!comboboxname = UCase(Me!comboboxname)
End Sub

On the other hand since a combo *selects existing data* from a table or list,
why not have them all uppercase already????

 

[Avid Fan]

Use code in the combo box's AfterUpdate event:

Private Sub comboname_AfterUpdate()
Me!comboboxname = UCase(Me!comboboxname)
End Sub

On the other hand since a combo *selects existing data* from a table or list,
why not have them all uppercase already????

When you do a search on in a combobox or anything else it looks weird
(to me at least) if the input data is not uppercase particularly if you
are searching uppercase data.

Thanks for your help.