what is the function for changing text to proper case/title case?

G

Guest

Does anyone know if there is a function in Access 2000 to change text into
proper case / title case? There used to be the function - PROPER(text) but it
doesn't seem to work any more.

Thanks
 
D

Douglas J Steele

AFAIK, there was never a Proper function in Access: perhaps you had a
custom-written one in whatever database you used previously.

The closest there is in Access is the StrConv function with a conversion
argument of vbProperCase (which equals 3). That will convert the first
letter of every word in string to uppercase:

?StrConv("is there is a function in Access 2000", vbProperCase)
Is There Is A Function In Access 2000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Title Or Proper Case 5
Field with Proper Case 2
proper case in access 4
Changing case in database 4
Title Case 3
How do you change text in a table to "Proper Case" 12
text manipulation- proper case 2
Change Upper Case to Title Case 1

Top