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
 
Back
Top