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

  • Thread starter Thread starter slagg7575
  • Start date Start date
S

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!
 
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?
Click to expand...
Imho the Office spelling correction does this automatically, if activated.


mfG
--> stefan <--
 
Hi,
I looked in the options, spelling but did not see an option for it? Can
u help me?
Thanks!
 
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!
Click to expand...

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