Change input to Combobox to UPPERCASE

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.

On 16/03/2010 12:12 AM, Avid Fan wrote:
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.

On 16/03/2010 12:23 AM, Avid Fan wrote:
On 16/03/2010 12:12 AM, Avid Fan wrote:
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.

Forget it. It is working now. Thanks

On Tue, 16 Mar 2010 00:12:27 +1100, Avid Fan wrote:

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????
--

John W. Vinson [MVP]

On 16/03/2010 10:07 AM, John W. Vinson wrote:

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.