Access - Set all names to upper case

January 2017




Issue


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?==

Solution

  • 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


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 (ccm.net).