Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Case for Labels?

Status
Not open for further replies.
Fortborg

Fortborg

Technical User
Jul 26, 2001
15
0
0
US
I have a table with Address information used in letters so it's all been entered in "John Smith" format, but to print labels I need the case changed to "JOHN SMITH". How can I do this?
 
Sort by date Sort by votes
UCase()

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
Putting the "greater than" sign in the control's format property works too.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Labels not aligned when Can Grow/Shrink enabled 1
Replies
7
Views
72
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
106
dhookom
dhookom
MattGreer
  • Locked
  • Question
VBA to Change Report Header - Inside the report? 1
Replies
7
Views
161
dhookom
dhookom
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
54
GPnew
GPnew
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
67
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top