| title | keywords | f1_keywords | ms.service | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|---|---|
Table Field |
vbaac10.chm13812 |
|
access |
b2bf5df9-f8f4-4cca-7a09-1271350e3614 |
06/08/2017 |
medium |
Applies to: Access 2013 | Access 2016
Table fields are separate pieces of information that make up a record within a table. You can control the appearance of data, specify default values, and speed up searching and sorting by setting field properties in the Field Properties section of table Design view.
Microsoft Access uses field properties when you view or edit data. For example, the Format, InputMask, and Caption properties that you set affect the appearance of table and query databases. The controls on new forms and reports that are based on the table inherit these properties by default. Use other properties to set rules for data or to require data entry in your fields, which Microsoft Access enforces whenever you add or edit data in a table.
- Access for developers forum
- Access help on support.office.com
- Access help on answers.microsoft.com
- Search for specific Access error codes on Bing
- Access forums on UtterAccess
- Access wiki on UtterAccess
- Access developer and VBA programming help center (FMS)
- Access posts on StackOverflow
[!includeSupport and feedback]