How do I make a database output CAPITALS in Reports?

B

bert32hid

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! :)
 
A

Al Camp

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)
 
B

bert32hid

Thanks mate.... your assistance that has solved the problem is greatly
appreciated!
 
B

Bruce

Go to the properties for each field you wish to show in Upper Case and in
the Format Box enter > symbol.

Bruce
 
Top