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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Title Case 3
Change case from caps to title 3
Field with Proper Case 2
Change Upper Case to Title Case 1
Changing case in database 4
proper case in access 4
populating an Access table from a text file 4

Back
Top