HOW DO YOU MAKE ALL OF YOU LETTERS IN ALL CAPS ONCE IT IS ALL TYP.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a database I am working in, and i did not know it was supposed to be
in all CAPS, how do i make it all Capital letters now?
 
You can use an Update query to change everything for you.

Add the table to query builder and drag all of the text fields that you need
to change to the grid. Change the query to an Update query (you can do this
in the Query menu when you've got the query in Design mode). That will add a
row "Update To" underneatch the Field and Table rows. For each field you
need to change, put UCase([FieldName]) in that row. (Replace FieldName with
the appropriate name for each field).

Since this is a permanent change, I'd recommend trying it on a copy of the
table first!
 
Back
Top