Using "Proper" Format In Access

[jobb]

In Excel, you can format text using PROPER so that the first letter of each word is capitalized, and the rest are lower case. Is there a similar way I can use this as a calculated field in Access?

 

[Russell Hauf]

I think you'll have to use a function. Paste the following function into a module:

Function GoProper(strText As String) As String
    GoProper = StrConv(strText, vbProperCase)
End Function

Then, you can use GoProper in your query, something like:

• Proper: GoProper([fldToMoveToProperCase])

or

• Proper: GoProper([fld1] & " " & [fld2])

Hope this helps - let us know if you have questions,

Russell

 

[jobb]

okay, I've never used modules before, but I tried it, and I saved it as "GoProper". Then I put it in the query like you said and I got an error message "Undefined function 'GoProper' in expression.

 

[Russell Hauf]

Would need more info. Can you paste your SQL? Also, don't save the module as GoProper - save it as something else.

To view the SQL, open your query in Design View, then go to View-SQL View.

-rh

 

[jobb]

thanks for your help..

Here is the SQL from my append query.

INSERT INTO [USB Leads Import table] ( Name )
SELECT Properize([primary borrower] & " " & [MI]) AS [prim borrower]
FROM [Focus Import];

I renamed what you told me to put into a module "properize". I'm still getting the "Undefined function" error message.

 

[jobb]

never mind.. I figured it out. I needed to use "goproper" in my query, not "properize". Thanks again!