convert to uppercase

[tekila]

To convert values entered in a combobox to uppercase, this was the code I used:

Me!Code = UCase(Me!Code)

The desired result was implemented in the control source (field in underlying table), but the row source of the combobox of another form that is this field in the underlying table was not converted to uppercase.

How do I solve this?

 

[67peshawar294]

Hi,
Try placing a > in the format line of your combo box, also works in any table or form.
Jim

 

[Aivars]

Create query for combobox rowsource by using function UCase():

Example:
me.cboCombo.rowsource="Select ID, Ucase(FirstName) as FN From MyTable;"

Aivars