Changing a field from all CAPS to "proper" format in access

[Guest]

I know how to convert a field from all caps in excel, but can you do it in
access ?

 

[Rick B]

You can, but keep in mind that some names won't follow the rule...

McDonald
de la Rosa


It is a better idea to make your users format the field correctly.

 

[Guest]

You say "You can"..... so what is the formula ? Do you do it in an update
query or something along those line ????

 

[Guest]

In the AfterUpdate Event use: strNameLast = StrConv(strNameLast,
vbProperCase). Change 'strNameLast' to the field name of your database. In
some cases, like "O'CONNOR", trhe result is "O'connor". If the name is
entered like, "O CONNOR" the result will be "O Connor". So, only the first
letter after a space will be capatalized.

 

[Guest]

thanks - I'll try that.

In the AfterUpdate Event use: strNameLast = StrConv(strNameLast,
vbProperCase). Change 'strNameLast' to the field name of your database. In
some cases, like "O'CONNOR", trhe result is "O'connor". If the name is
entered like, "O CONNOR" the result will be "O Connor". So, only the first
letter after a space will be capatalized.