Access - Set all names to upper case

April 2018


I've designed a table in Access and I want each entry in the "Name" field to be automatically converted to uppercase. How must I proceed?==


  • Open the table in edit mode.
  • To do this, select the table in the DATABASE button and click on the CHANGE button. Then select the NAME field. In the GENERAL tab at the bottom of the window, type the > symbol in the FORMAT field.
Published by aakai1056. Latest update on May 10, 2011 at 01:11 PM by aakai1056.
This document, titled "Access - Set all names to upper case," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Access: Filter a date
Microsoft Access - Automatically enter the current date