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!

  • 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!

Printing Capitals

Status
Not open for further replies.

pd2222

Programmer
Oct 15, 2001
14
0
0
GB

Hi,

I have written some code so that the data from my Access form is transfered into a Word document which then prints. However, one of my text boxes on the form is formatted to only contain upper case but when this is transfered to the Word document it reverts back to the users original input i.e. lower case. Is there a way to ensure it prints in upper case?

Keza
 
UCase() will do the trick,
Check Windows Help for verbage.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top