Update query to capitalized text

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

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

Thanks,
Jasper
 
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
Capitalize text in a field 8
format a text field 1
Coverting all caps in a field to proper 3
How can i tag up a record 6 months before it expires 4
Convert Field from 10 positions to 4 1
Case being changed in table 1

Back
Top