Capital letters option for Combo box

[efandango]

I have a combo box that uses a lookup to a table that is also shared with
other text boxes on other forms. But for this Combo only, I want to have the
data (addresses) appear all in Caps, ideally without changin the underlying
data table which would mean that the other text boxes would see them in their
native format (upper/lower)


Can this be done?

 

[Graham Mandeno]

Hi efandango

Typically the RowSource of your combo box will be a query (either a saved
query or a SQL SELECT statement) in a form like this:

Select AddressID, AddressText from tblAddresses order by AddressText;

You can use the UCase function in your query to convert text to uppercase:

Select AddressID, UCase( [AddressText] ) from ...

 

[efandango]

perfect!,

Thanks Graham

Hi efandango

Typically the RowSource of your combo box will be a query (either a saved
query or a SQL SELECT statement) in a form like this:

Select AddressID, AddressText from tblAddresses order by AddressText;

You can use the UCase function in your query to convert text to uppercase:

Select AddressID, UCase( [AddressText] ) from ...

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a combo box that uses a lookup to a table that is also shared with
other text boxes on other forms. But for this Combo only, I want to have
the
data (addresses) appear all in Caps, ideally without changin the
underlying
data table which would mean that the other text boxes would see them in
their
native format (upper/lower)


Can this be done?