Capitalizing only first intitial of names

D

Dakota

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
 
J

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.
 
R

Randy Harris

Jeff Boyce said:
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>
Click to expand...

?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
 
Top