@PROPER Function

[JimP]

Is there an MS-Access or VBA function that duplicates the Excel @PROPER
function, i.e. capitalizes the first character of a word and makes the rest
lowercase?

 

[Dirk Goldgar]

Is there an MS-Access or VBA function that duplicates the Excel @PROPER
function, i.e. capitalizes the first character of a word and makes the
rest lowercase?

See the online help for StrConv.

 

[John W. Vinson]

Is there an MS-Access or VBA function that duplicates the Excel @PROPER
function, i.e. capitalizes the first character of a word and makes the rest
lowercase?

Strconv(<string>, 3)

will do it - in VBA you can use vbProperCase as a synonym for 3.