Text Formatting

[Jay]

I have data in an access table. Some of the text is in
all caps while the rest is not. Is there a way to change
the text format for the entire table so that the first
letter is capitalized and the rest of the letters are
small? The data can be copied into either a word
document, and excel spreadsheet, or an access table but I
can't figure out how to change the entire table text
format in any of these programs.

 

[Cheryl Fischer]

This can be done by creating and running an Update Query. I am not clear
as to whether you want the first letter of the field or the first letter of
each word in the field capitalized, so here are examples of both:

Presuming the name of the field in your table is: MyField,

1. To change the first letter of the field to capitalized and the rest of
the field to lower case (i.e., NOW IS THE TIME to Now is the time) , place
the following expression in the Update to: row of an Update query

Left([MyField], 1) & LCase(Mid([MyField], 2))

2. To change the first letter of each Word in the field to Upper Case,
leaving the rest in Lower Case (i.e., NOW IS THE TIME to Now Is The Time),
place the following expression in the Update to: row of an Update query

StrConv([MyField], 3)