StrConv Format and Proper Use

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

Guest

I have an access DB and i need to convert my FirstName and LastName fields
to proper case. I have absolutly no idea how this is done. i have read some
of the other threads and it appears i need to use the following string:

=StrConv([FirstName],3)

But where do i put it and what else needs to accompany it so that this will
work.

Thanks in advance for any help anyone can provide
Nelson
 
Nelson,

If you mean to change the existing data in the database, you should use
an Update Query. Make a query in design view, based on your table.
Make it into an Update Query (select Update from the Query menu). In
the 'Update To' row of the query design grid, in the FirstName column
enter StrConv([FirstName],3) and in the LastName column enter
StrConv([LastName],3)

You will need to be aware that in some cases this will not produce what
you want. For example DiMaggio, McDonald, O'Reilly, Smith-Kline, van
Gogh, da Vinci, etc.
 
.... sorry, I should have also pointed out that you can then run the
query by clicking the toolbar button with the red [!] icon. Maybe a
good idea to make a backup copy of the database first.
 
Back
Top