Formatting a List Box for Uppercase

[FredK]

I'm trying to format the data in a List Box to be upper case. I've tried
">" in the field properties, but that doesn't work. Below is the SQL
Statement in my query.
Any idea where I would insert something to make the First_Name and Last_Name
fields to be all upper case letters?


SELECT DISTINCT [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME] AS Expr1
FROM tbl_PMS_Persons
ORDER BY [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME];


Thanks in advance,
Fred

 

[Guest]

Try changing the Row Source of the list box

SELECT DISTINCT UCase([FIRST_NAME]) & " " & UCase([LAST_NAME]) AS Expr1
FROM tbl_PMS_Persons
ORDER BY [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME];

 

[FredK]

That worked great!
Thanks!

Try changing the Row Source of the list box

SELECT DISTINCT UCase([FIRST_NAME]) & " " & UCase([LAST_NAME]) AS Expr1
FROM tbl_PMS_Persons
ORDER BY [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME];
--
Good Luck
BS"D

I'm trying to format the data in a List Box to be upper case. I've tried
">" in the field properties, but that doesn't work. Below is the SQL
Statement in my query.
Any idea where I would insert something to make the First_Name and
Last_Name
fields to be all upper case letters?


SELECT DISTINCT [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME] AS
Expr1
FROM tbl_PMS_Persons
ORDER BY [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME];


Thanks in advance,
Fred