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

How to remove a combination of letters and special characters 2
Word doc keeps changing to ALL CAPS 0
Justification function versus wide spaces 0
Excel does not accept text format! 0
Mail Merge Directory Conditional Page Break 0
Disable Outlook AutoCorrect with GPO 0
Template with fields and premade texts.. 0
Insert name and adress from a list in a word document 1

Top