Problem with capitalized letters showing up lower case in a report

[Sue]

So in the table & query on which my report is based, I "see" capital letters
in a 6-character field where the first character is always a letter, the
second character may be a letter or a number, and last 4 characters are
always numbers. I have an input mask:
LA0000.
In my report, I use a concatenated expression that includes the field above.
Some of my letters are lower case.
is there a fix for this?

 

[Tom Wickerath]

Hi Sue,

You can use VBA code in your form to ensure that all letters entered are
saved as upper case. Or, I suppose you could add the UCase function with your
concatenated expression. Something like this:

Original expression:
=[Whatever]

Modified expression:
=UCase([Whatever])


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[John W. Vinson]

So in the table & query on which my report is based, I "see" capital letters
in a 6-character field where the first character is always a letter, the
second character may be a letter or a number, and last 4 characters are
always numbers. I have an input mask:
LA0000.
In my report, I use a concatenated expression that includes the field above.
Some of my letters are lower case.
is there a fix for this?

Are you perhaps using a Format in the table with a > character? If so, it will
*display* text in upper case, regardless of the stored case.

To see all caps in the form/report, you can set the format of the textbox in
which you display the field to

">"

Alternatively, you can run an Update query to actually store upper case in the
table; make a backup of your database just in case, and update the field to

UCase([fieldname])