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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field formatting 3
Coverting all caps in a field to proper 3
global text change 3
ALL CAPS to PROPER 14
Initial Caps Problem 6
format a text field 1
Formatting inital caps 2
Caps Lock Indicator 3

Back
Top