Format Name

[sandrao]

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

 

[ruralguy via AccessMonster.com]

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

 

[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

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

 

[ruralguy via AccessMonster.com]

Because there is no space between the "." and the Last Name?
a.LastName
not
a. LastName

Me.YourControlName = StrConv(Me.YourControlName, vbProperCase) in the
BeforeUpdate event of the control should do it.

[quoted text clipped - 8 lines]

Message posted viahttp://www.accessmonster.com

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

 

[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