Capitalizing only first intitial of names

[Guest]

How do you set the format so that only the first letter of a name is
capitalized.
Example: john doe = John Doe after formatting..

Thanks

Dakota

 

[Jeff Boyce]

Dakota

Depending on the version of Access you are running, you can use the
StrConv() or Proper() functions to capitalize the first letter of a text
string.

To get John Doe from john doe, you'd need to have "john" and "doe" as
separate fields.

 

[Randy Harris]

Dakota

Depending on the version of Access you are running, you can use the
StrConv() or Proper() functions to capitalize the first letter of a text
string.

To get John Doe from john doe, you'd need to have "john" and "doe" as
separate fields.

--
Regards

Jeff Boyce
<MS Office/Access MVP>

?StrConv("john doe",vbProperCase)
John Doe

Dakota, this should help, but keep in mind it won't fix everything.

Eric von Holden
Thomas MacEvity
MaryAnn Lewis
BillyJoe McNight

HTH,
Randy