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)
 
Go to the properties for each field you wish to show in Upper Case and in
the Format Box enter > symbol.

Bruce
 
Back
Top