Access - Set all names to upper case

October 2016


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.

Related :

This document entitled « Access - Set all names to upper case » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.