You can use StrConv - you might want to start by making a backup of your
database! Then create a SELECT query that includes the field that you wish to
update. Convert this query to an UPDATE query – use the Expression Builder in
the Update row of the grid as follows:
Field: MyFieldName
Table: MyTableName
Update To: StrConv([MyFieldName], 3)
Note for Uppercase use 1 and lower case use 2 – this actually changes the
case rather than the format property which only changes how text is displayed.
mktg@wfi said:
Is there a function that will convert my text from ALL CAPS to Proper Case?
I've found some postings with vbProperCase but I don't know vb.