Capital letters option for Combo box

  • Thread starter Thread starter efandango
  • Start date Start date
E

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?
 
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 ...
 
perfect!,

Thanks Graham

Graham Mandeno said:
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

efandango said:
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?
Click to expand...
Click to expand...
 
Back
Top