Access 2007 - Text Case

  • Thread starter Thread starter MBaronet
  • Start date Start date
M

MBaronet

Can text case be changed in a field. For example, the entire field is in
upper case. I need to change it to title case.
 
Can text case be changed in a field. For example, the entire field is in
upper case. I need to change it to title case.
Click to expand...

Run an Update query updating the field to

StrConv([fieldname], 3)

That Will Convert It To Proper Case (Like This).

2 will CONVERT IT TO ALL CAPS; 1 will convert it to lower case.

John W. Vinson [MVP]
 

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

Field Formats 3
Text Fields changing case 2
Upper Case 8
Table Design - Initial Capitals Formatting 4
Capitalize first letters in field 5
Formatting cells to only upper case 5
Access How to record date/time when specific field is modified in Access 2007 0
Change text from lower case to upper case in Access 2007 1

Back
Top