Change to CAPS?

  • Thread starter Thread starter Doug Boufford
  • Start date Start date
D

Doug Boufford

Running Access 97
Have a db of ~800 records, where some were entered using all caps, some entered using
no caps & some where just the first letter was capitalized.

What would be the easiest method to change all of the records, so that either all
fields were in CAPS when printed or all fields had just the first letter capitalized?

I've looked everywhere but haven't come up with any "smart" ideas.

TIA

Doug
 
Write an Update query that sets MyField to UCase([MyField]) will make it all
upper case. Setting it to UCase(Left([MyField], 1)) & LCase(Mid([MyField],
2)) will make the first letter capitalized, and all other lower case.
 
Thanks - That didn't hurt a bit! :)
Write an Update query that sets MyField to UCase([MyField]) will make it all
upper case. Setting it to UCase(Left([MyField], 1)) & LCase(Mid([MyField],
2)) will make the first letter capitalized, and all other lower case.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Running Access 97
Have a db of ~800 records, where some were entered using all caps, some
Click to expand...

entered using
no caps & some where just the first letter was capitalized.

What would be the easiest method to change all of the records, so that
Click to expand...

either all
fields were in CAPS when printed or all fields had just the first letter
capitalized?

I've looked everywhere but haven't come up with any "smart" ideas.

TIA

Doug
Click to expand...
Click to expand...
 
use a format of > (yes, the greater than sign). here is
the documentation on it...
Format Property - Text and Memo Data Types
You can use special symbols in the setting for the Format
property to create custom formats for Text and Memo fields.

Setting
You can create custom text and memo formats by using the
following symbols.

Symbol Description
< Force all characters to lowercase.
Force all characters to uppercase.
Click to expand...

Example
The following are examples of text and memo custom formats.

Setting Data Display
format sign input resulting output
davolio DAVOLIO
Davolio DAVOLIO
DAVOLIO DAVOLIO
Click to expand...

< Davolio davolio
< davolio davolio
< DAVOLIO davolio
************* have a great day *****************
 
You can use an update query and in the Update To use the
format statement and the '>' sign to change them all to
uppercase. For example firstname is a column in my table
so the Update To would look like this:
Format([firstname],'>')

Hope this helps!
 
Back
Top