upper case

[tracktraining]

Hi All,

I wrote a query and am using that to populate a report. The user is prompt
to enter three different criteria. One of the criteria is asking the user to
enter in the Revision code for the part number. The revision code should
always be in uppercase. So when the user enter the code in lower case, it
appears in the report as a lower case, is there a way for me to change it to
default uppercase?

Thank you for your help,
Thi

 

[Al Campagna]

Thi,
On your report, use a calculated field to always display the Revision
Code in upper case.
= UCase(RevisionCode)
OR
Using a bound text control with RevisionCode as it's ControlSource, set
the format for that field to...That also will cause any RevisionCode to display in upper case.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[tracktraining]

THANKS!


--
Learning

Thi,
On your report, use a calculated field to always display the Revision
Code in upper case.
= UCase(RevisionCode)
OR
Using a bound text control with RevisionCode as it's ControlSource, set
the format for that field to...
That also will cause any RevisionCode to display in upper case.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."