Update query to capitalized text

J

Jasper Recto

Does anybody know how I can create an update qurey that would capitalize the
text in a field?

Thanks,
Jasper
 
J

Jeff Boyce

Jasper

Do you really need to capitalize the text in the field, or would it be
sufficient to display an "ALL CAPS" version of the text in the field?
Remember, once you make the value ALL CAPS, it's going to be a difficult,
painful bit of work to get back to upper/lower case.

Create a query. Use the UCase() function.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Change the color of each capital letter in a rich text memo field. 0
Allow Caps Only in Text Fields 2
format a text field 1
Capitalize text in a field 8
Coverting all caps in a field to proper 3
Convert Field from 10 positions to 4 1
Changing all Caps in a column 3
How can i tag up a record 6 months before it expires 4

Top