Format Name

S

sandrao

How can I make sure that a name that is entered as a. smith will be
formatted to A. Smith?
 
S

sandrao

Me.YourControlName = StrConv(Me.YourControlName, vbProperCase) in the
BeforeUpdate event of the control should do it.
..using Your Control Name of course.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted viahttp://www.accessmonster.com
Click to expand...

It does correct the first part....the initial is corrected but the
latter part of the first name remains in small letters.
 
J

Jeff Boyce

Does your table hold a single field for the name, or do you have FirstName
and LastName fields (the latter approach is recommended)?

What would you consider to be the "proper" capitalization of something like:

alexandro van de vigge
jean claude van damm
william o'brien

As suggested elsethread, you can use the StrConv() function, but this only
gets you started. You may have to resort to USB (*using someone's brain*)
to finish the job.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top