format a text field

A

alison.justice

How can I format a text field that the data is in all caps to where every
word starts with a capital letter?
 
S

Steve Schapel

Alison,

Making sure you have a backup of your database, use an Update Query to
update TheField to...
StrConv([TheField],3)

--
Steve Schapel, Microsoft Access MVP


alison.justice said:
How can I format a text field that the data is in all caps to where every
word starts with a capital letter?
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4120 (20090601) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

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

Field formatting 3
Case being changed in table 1
Change the color of each capital letter in a rich text memo field. 0
Look Up Tables 5
Table set up 5
Coverting all caps in a field to proper 3
From large to small letters 4
Text to date format? 0

Top