Upper case field text formatting

H

Hoja, Michael

We have an Access Database that has fields which have been populated by sloppy users. A typical example of one of the address fields says "13 abercorn street". This needs to be "13 Abercorn Street" but I need to make similar changes to all record fields and the sort all fields so that the first letter of every word is in Uppercase. Is there a way I can change this automatically? This is so that we can do presentable mail merges.

Can someone help me on this please?
 

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

Address Format changed after Migration 0
Upper case field text formatting 5
upper case lower case 0
Formating bolded text exclusively. 0
Changing margins on 2nd page of letterhead template 4
changing case 10
Name break into half and reverse to upper case 1
Sorting address fields 4

Top