Upper to lower case conversion

  • Thread starter Thread starter android
  • Start date Start date
A

android

For some reason I have entered all my records of my library in capitals
I really would like to convert them to normal case (sentence case?)
i.e. Caps for for first letters of records and for proper nouns.
e.g. ALICE IN WONDERLAND

LEWIS CARROL

HARDBACK

to Alice in Wonderland

Lewis Carrol

Hardback

etc.

Trouble is I am a complete novice. I know that there are functions but
aside from entering data into sheets I have created I don't know how t
convert the 504 records without typing each one out again.

Is there a routine / utility which would convert. Is there anyone ou
there who can explain step by step in VERY simple terma please.

Mike Cowi
 
Use StrConv() to convert to proper case.

1. Create a query into your table.

2. Change it to an Update query (Update on Query menu).
Access adds an Update row to the grid.

3. In the Update row under the field called BookTitle, enter:
StrConv([BookTitle], 3)

4. Run the query.

You will have to manually sort out words like McDonald, O'Conner, d'Bruin,
In, etc.
 
Allen, many many thanks for your help. 504 records now converted! I hop
that those who charge for services do as good a job as you have fo
free. Once again many thanks. I have added your website to m
favourites menu.

Mike Cowi
 
Back
Top