![ms access limits ms access limits](https://i.ytimg.com/vi/XXcDtq3k1rc/maxresdefault.jpg)
You shouldn't change field data type unless you are certain your field data is in the correct format for the new data type. Click the Data Type drop-down arrow.Īll of the entries formatted as hyperlinks Select the Fields tab, then locate the Formatting group.Select the field whose data type you want to change.
![ms access limits ms access limits](http://www.subscriptiontemplates.com/uploads/images/hunting-ppt-background-low-big-1-2230-1.jpg)
To change the data type for existing fields: There are three main types of rules you can set for a field: data type, character limit, and validation rules. For example, you can only do math with data entered in number or currency fields, and you can only format text entered into text fields. Rules can also determine which options you have for working with your data. Making sure to enter your data in a standard format will help you better organize, count, and understand it. While you might recognize that two and 2 or NC and North Carolina are the same thing, Access will not and therefore won't group these things together. Why is this important? Computers aren't as smart as humans about certain things. Databases often include rules because they help ensure users enter the correct type of data. When you set field data type, you are really setting a rule for that field. On the previous page, you learned about setting the data type for new fields. If you already have several fields, you may need to scroll all the way to the right to see this option.
![ms access limits ms access limits](https://www.techpowerup.com/img/NpEOMFH2k4bAOkCA.jpg)
All of these changes can help make your tables even more useful. In addition to making basic modifications to your tables, like adding and moving fields, you can make more advanced modifications that let you set rules for your data. You will need to have Access 2013 installed on your computer in order to open the example.
#Ms access limits download#
If you would like to follow along, you'll need to download our Access 2013 sample database. Throughout this tutorial, we will be using a sample database.