In Access how can I highlight records and make them all caps? I .

[Guest]

I want all records in a certain table to be capitalized without having to
retype them all. In format/font I don't have the option of all caps. what do
I do.

 

[Albert D. Kallal]

You could just make the "report" SHOW the company name, or family name in
all caps, and still allow upper/lower case during data entry.

(this is better, since then for word merge form letters etc, then you don't
have to deal with "upper case" last names.

So, perhaps it would be better to just "display" the result in upper case
then actually convert the data???

Amway, if you MUST, and you REALLY do need the data in upper case, then you
can simply create a update query.

Just whack ctrl-g, and at the command prompt type:

docmd.RunSQL "update tblcontacts set Company = strconv(Company,1)"