How to switch to title case in Access table?

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

Guest

The database I queried has all of its info in caps -- how can I switch the
names to title case?
 
The database I queried has all of its info in caps -- how can I switch the
names to title case?
Click to expand...

Run an Update query updating [Namefield] to

StrConv([namefield], 3)

Note that this will cause some names to be improperly cased: e.g.
MCNISH will become Mcnish instead of McNish, and DE LA TORRE will
become De La Torre instead of de la Torre.


John W. Vinson[MVP]
 
I am not exactly sure what your definition of "title case" is, however, one
option available is the StrConv function. It has an option for "proper
case" where the first letter of each work is capitalized. For example:

StrConv(MyField, 3)

The value of 3 is equivalent to proper case. See Access help for more
information on the function.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


The database I queried has all of its info in caps -- how can I switch the
names to title case?
 

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

Similar Threads

Change case from caps to title 3
Nintendo Switch overtakes the Wii U 0
The next Grand Theft Auto title has been officially announced 0
Access 2007 database name disappears from Title Bar 3
Changing existing data in database to title case 1
SQL: Finding Data That Is In One Table But Not The Other 4
Changing Case 5
How to export table from outlook into ms access table? 0

Back
Top