Change Capitol letters to small

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hello in a table there is a field in which all Entries are in Capitol
letters for example SMITH. Is there a way to change that with small letters
except the first letter. for example Smith?
Thank You
Jimmy
 
Jimmy,

You would use an Update Query for this. Update YourField to...
StrConv([YourField],3)

Please post back if you need more specific help.
 
Jimmy,

It's quite simple. Access built-in function StrConv (look it up in help)
does conversions on strings, one of which (parameter 3) is conversion to
Proper case. You can use it in a simple Update query like:

UPDATE MyTable SET MyTable.LastName = StrConv([LastName],3)

where I have assumed the table name to be MyTable, and the field name to
be LastName. Start making a new query in design view, add no table,
revert to SQL viewe and paste the SQL expression above; substitute the
actual table and field names and run the query.

Note: before trying out something you don't feel very confident about,
*always* make a back-up copy first!

HTH,
Nikos
 
The other posters are correct.
Remember, though, that with this paradigm, O'Neill becomes O'neill, and
deCaprioli becomes Decaprioli.
That's one reason some folks prefer just to use all capitals.
 
Back
Top