StrConv Format and Proper Use


N

Nelson

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
 
Ad

Advertisements

S

Steve Schapel

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.
 
Ad

Advertisements

S

Steve Schapel

.... 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top