Upper case field text formatting

  • Thread starter Thread starter Hoja, Michael
  • Start date Start date
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?
 
Back
Top