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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
You say "You can"..... so what is the formula ? Do you do it in an update
query or something along those line ????
 
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.
 
thanks - I'll try that.

Jim Ory said:
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.
Click to expand...
 
Back
Top