Proper Function

[DW]

Hello - I am trying to use Proper Function in Query. I
have used this function in the past with a problem, but
everytime I try to use the following Proper([Last_Name]).
I get the following error message "Undefined
Function 'Proper' in expression. Does anyone know why I am
getting this message.
Thanks in Advance
Dw

 

[Arvin Meyer]

To my knowledge, there is no Proper() function in Access. I believe what you
want is the StrConv() function, which for propercase would be:

StrConv([Last_Name], vbProperCase)

or in a query:

StrConv([Last_Name], 3)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Cheryl Fischer]

Access does not have a Proper function. Try using the StrConv() function
in your query with the numeric argument for vbProperCase:

ProperLastName: StrConv([Last_Name], 3)

hth,