1. Home
  2. MS Office

Change Access 2010 Table Field’s Data Type

In Access 2010, you will a lot of Table Tools to let user change table fields settings. Since data type has to be specified for each field, it also allows user to change the data type on the fly without opening database in design mode. Let’s see how to change the data type of an existing field.

For changing the Field’s data type, select the field by clicking column title and head over to Table Tools Fields tab. From Formatting group, under Data Type option, select a data type for the selected field.



  1. The title says “Access 2010.” The screenshot clearly shows “Access 2007.” Completely different interface & navigation. Total fail.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.