Auto capitalize "Dr. G. Smith" in Access form?

[slagg7575]

Hi all,

I have a simple form with a Name field that would consist of this
format "Dr. G. Smith". How do I code so that Access would auto
capitalize the Dr. G. Smith if someone entered it as dr. g .smith? I
know how to do normal names, but this one is a little harder....any
ideas?

Thanks!

 

[Stefan Hoffmann]

hi,

I have a simple form with a Name field that would consist of this
format "Dr. G. Smith". How do I code so that Access would auto
capitalize the Dr. G. Smith if someone entered it as dr. g .smith? I
know how to do normal names, but this one is a little harder....any
ideas?

Imho the Office spelling correction does this automatically, if activated.


mfG
--> stefan <--

 

[slagg7575]

Hi,
I looked in the options, spelling but did not see an option for it? Can
u help me?
Thanks!

 

[MikeB]

StrConv([tblFieldName],vbPropercase)

or

StrConv([tblFieldName],3)

 

[fredg]

Hi all,

I have a simple form with a Name field that would consist of this
format "Dr. G. Smith". How do I code so that Access would auto
capitalize the Dr. G. Smith if someone entered it as dr. g .smith? I
know how to do normal names, but this one is a little harder....any
ideas?

Thanks!

Code that control's AfterUpdate event:

[ControlName] = StrConv([ControlName],3)

Be aware that this will not properly capitalize some names.
Hyphenated names, i.e. Dr. John Smith-Jones will become Dr. John
Smith-jones, and some names should contain non-capitalized words, i.e.
Dr. John van Houten, which will become Dr. John Van Houten, while Dr.
John O'Brien will become Dr. John O'brien.