Change input to Combobox to UPPERCASE

  • Thread starter Thread starter Avid Fan
  • Start date Start date
A

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.
 
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.
Click to expand...


Should have mentioned that >???????????? in the imput mask does not work.
 
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.
Click to expand...

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????
 
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????
Click to expand...


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.
 
Back
Top