Skip to main content
Business LibreTexts

12.7: Field Properties

  • Page ID
    46620
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Learning Outcomes

    • Differentiate among field properties

    Regardless of how you created your table, it is a good idea to examine and set field properties. While some properties are available in Datasheet view, some properties can only be set in Design view. To switch to Design view, right-click the table in the Navigation Pane and then click Design View. To see a field’s properties, click the field in the design grid. The properties are displayed below the design grid, under Field Properties.

    To see a description of each field property, click the property and read the description in the box next to the property list under Field Properties. You can get more detailed information by clicking the Help button.

    Field Properties sets boundaries on what/how data is entered into table fields. There are five types of field properties:

    • Field Size: sets the maximum number of characters that can be entered into a text field.
    • Format: sets how the data is to be displayed in the table field.
    • Input Mask: sets the rules as to how data can be entered so that data is entered correctly.
    • Default Value: sets the default value that will appear in the table field each time a new record is entered.
    • Required: sets whether a value is required to be entered into this table field.

    Learn More

    For more detailed information, Microsoft Access Help is an excellent resource and can be found by following this link: Field Properties Access Help

    Contributors and Attributions

    CC licensed content, Original
    • Field Properties. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    12.7: Field Properties is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?