How do I make a database output CAPITALS in Reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a database output CAPITALS in Reports?

I can not seem to find any function that will allow the data in the database
to be put in UpperCase (even if it was not typed that way).

The only way UPPER(xxx) seems to work is if just plain text is put there and
not a field, so how does a field work? How do you make a field all uppercase?

Your support would be greatfully appreciated! :-)
 
Bert,
Formatting a text control for > will capitalize all the characters.
Or, the UCase function will do the same... use the ControlSource for the field..
=Ucase(YourTextControlName)
 
Thanks mate.... your assistance that has solved the problem is greatly
appreciated!
 
Go to the properties for each field you wish to show in Upper Case and in
the Format Box enter > symbol.

Bruce
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coding in Text box on a report 3
Can't create a report from my query in Access 1
Capitalizing a Date 12
Converting GPS coordinates to decimal in Report 0
In my report, why does ">" format make memo field lose data? 3
Outputting a report to Word 2
How do I create a complex report? 1
Capitalize Text 3

Back
Top