Converting to Upper Case in Access 2002

[srossbach]

I am attempting the folling in an Update Query within an Access 2002 Database.

StrConv([member]![last name],1)

The table name is 'Member' and the field name "last name' and I am attempting to convert to UpperCase. This same language worked in Access 97 format.

But in this 2002 version I get the following error:

"Undefined function 'StrConv' in expression"

Any suggestions?

 

[tonyireland]

Try
Ucase(left([member]![last name],1))

 

[TLady]

Or try

http://www.planet-source-code.com

I saw whole bunch of Upper Case solutions there

TIA