Field Options
Microsoft Access - Table
 |
There is different options you have for a field. This helps the user in entering the correct information and limit mistakes. For example, You can have a phone number field. That is all numbers so you can set the field to only accept numbers and no alphabet. If the user accidentally hits a letter, it won't take it. You can set it to where it will only take 10 numbers so if you type 11, it will error out and won't let you. There is other options too. Here is the various options you can set for the field. (Click hyperlink for information on that field)