Proper() function

[Guest]

Is there a function in Access that does the same thing Proper() does in
Excel? Or perhaps a work-around?

The other option I can see is exporting to Excel, use the Proper() function
and import back into Access, but that seems rather awkward.

 

[Allen Browne]

The StrConv() function has an argument that gives proper case.

If you are working with a really old version of Access, there's one you can
copy here:
http://members.iinet.net.au/~allenbrowne/func-05.html

 

[Rick Brandt]

Is there a function in Access that does the same thing Proper() does in
Excel? Or perhaps a work-around?

The other option I can see is exporting to Excel, use the Proper() function
and import back into Access, but that seems rather awkward.

Check Help file for StrConv()


strConv("bob jones", vbProperCase) returns "Bob Jones"

in a query you would use the literal for the second argument.

strConv("bob jones", 3) returns "Bob Jones"