How to open field properties in access

Because there are so many different types of data, Access offers several different types of fields. A field’s data type restricts what type of information can be stored in a field. For example, you cannot enter text into a number field.

To change a field's type, you must be in Design View.

The field's data type is changed to the data type you specified.

You can also change a field's properties. A property is an attribute that defines an object’s appearance, behavior, or characteristics. For example, a car’s properties would include its color, make and model, and shape. A property for a numeric field might be the number of decimal places displayed or the maximum number of characters a field can hold.

To view and modify the Field Properties for a table, open the table in Design View.

1. In Design View, click the field that you want to change the properties of.
2. Click the property box you want to change and enter or select the new settings.

   The table at the end of this lesson describes many important field properties. Don’t worry if some of them seem confusing—you’ll get plenty of practice adjusting them in other lessons.

   It’s important to note that certain types of fields have their own sets of properties, so the properties may be different depending on the field.

Important Short Text Field Properties

Field Size	Text fields: The maximum number of characters (up to 255) that can be entered in the field. The default setting is 50. Number / Currency fields: Stores the number as a Byte, Integer, Long Integer, Single, Double, or Replication ID, or Decimal. The default setting is Long Integer.
Format	How the data in the field will be displayed on the screen.
Input Mask	Creates a format or pattern in which data must be entered.
Decimal Places	The number of decimal places in Number and Currency fields.
Caption	A label for the field that will appear on forms. If you don’t enter a caption, Access will use the field name as the caption.
Default Rule	A value that Access enters automatically in the field for new records.
Validation Rule	An expression that limits the values that can be entered in the field.
Validation Text	The error message that appears when an incorrect or restricted value is entered in a field with a validation rule.
Required	Specify if a value must be entered in the field. The default is No.
Indexed	Index the field to speed up searches and sorts performed on the field. The default is No.

{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2019-01-10T16:30:21+00:00","modifiedTime":"2019-01-10T16:30:21+00:00","timestamp":"2022-09-14T18:17:01+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"//dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"//dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"//dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General Microsoft","_links":{"self":"//dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"MS Access Field Properties for Making Sure That Data Entries Are Accurate","strippedTitle":"ms access field properties for making sure that data entries are accurate","slug":"ms-access-field-properties-for-making-sure-that-data-entries-are-accurate","canonicalUrl":"","seo":{"metaDescription":"Unfortunately, entering the data in an Access database table is one of the most tedious activities known to humankind. And because the activity is so dull, peop","noIndex":0,"noFollow":0},"content":"Unfortunately, entering the data in an Access database table is one of the most tedious activities known to humankind. And because the activity is so dull, people are prone to make mistakes when they enter data in an <a href=\"//www.dummies.com/software/microsoft-office/access/how-access-2019-works-and-how-you-work-with-it/\">Access 2019</a> database table. One way to cut down on mistakes is to take advantage of the Field Properties settings on the General tab in the Design view window.\r\n\r\n[caption id=\"attachment_259207\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259207 size-full\" src=\"//sg.cdnki.com/how-to-open-field-properties-in-access---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzL29mZmljZS0yMDE5LWFjY2Vzcy1maWVsZC1wcm9wZXJ0aWVzLnBuZw==.webp\" alt=\"Access field properties\" width=\"535\" height=\"184\" /> Establishing field properties.[/caption]\r\n\r\n \r\n\r\nThese properties determine what can and can’t be entered in the different fields of a database table. Some of the settings are invaluable. The Field Size property, for example, determines how many characters can be entered in a field. In a State field where two-letter state abbreviations are to be entered, make the Field Size property 2 to be certain that no one enters more than two characters. If the majority of people you’re tracking in an address database live in New York, enter NY in the Default Value property. That way, you spare data-entry clerks from having to enter NY the majority of the time. They won’t have to enter it because NY is already there.\r\n\r\nThe Lookup tab in the Field Properties part of the Design view window is for creating a data-entry drop-down list. It, too, is invaluable. If you happen to know that only four items can be entered in a field, create a drop-down list with the four items. That way, data-entry clerks can choose from a list of four valid items instead of having to enter the data themselves and perhaps enter it incorrectly.\r\n<h2 id=\"tab1\" >A look at MS Access Field Properties settings</h2>\r\nEspecially if yours is a large database, you’re encouraged to study the field properties carefully and make liberal use of them. The Field Properties settings safeguard data from being entered incorrectly. Following is a description of the different properties (listed here in the order in which they appear in the Design view window) and instructions for using them wisely. Which properties you can assign to a <a href=\"//www.dummies.com/software/microsoft-office/access/field-types-and-uses-in-access-2019-databases/\">field in Access</a> depends on which data type the field was assigned.\r\n<h3>Field Size</h3>\r\nIn the Field Size box for Text fields, enter the maximum number of characters that can be entered in the field. Suppose that the field you’re dealing with is ZIP code, and you want to enter five-number ZIP codes. By entering <strong>5</strong> in the Field Size text box, only five characters can be entered in the field. A sleepy data-entry clerk couldn’t enter a six-character ZIP code by accident.\r\n\r\nFor Number fields, select a value for the field size from the drop-down list. The table below describes these field sizes.\r\n<table><caption>Access Numeric Field Sizes</caption>\r\n<thead>\r\n<tr>\r\n<td>Field Size</td>\r\n<td>Description</td>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td>Byte</td>\r\n<td>An integer that holds values from 0–255.</td>\r\n</tr>\r\n<tr>\r\n<td>Integer</td>\r\n<td>An integer that holds values from –32,768– +32,767.</td>\r\n</tr>\r\n<tr>\r\n<td>Long Integer</td>\r\n<td>An integer that holds values from –2,147,483,648– +2,147,483,647.</td>\r\n</tr>\r\n<tr>\r\n<td>Single</td>\r\n<td>A floating point number that holds large values up to 7 significant digits.</td>\r\n</tr>\r\n<tr>\r\n<td>Double</td>\r\n<td>A floating point number that holds large values up to 15 significant digits.</td>\r\n</tr>\r\n<tr>\r\n<td>Replication ID^*</td>\r\n<td>A globally unique identifier (GUID) required for replication; this number is generated randomly.</td>\r\n</tr>\r\n<tr>\r\n<td>Decimal</td>\r\n<td>A number with defined decimal precision. The default precision is 0, but you can set the scale up to 28.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<em>^*Not supported by the <code>.accdb</code> file format.</em>\r\n<p class=\"article-tips tech\">The Single, Double, and Decimal field size options hold different ranges of numbers. For now, if you need to store numbers after the decimal point, choose the Double field size so that you cover most situations.</p>\r\n\r\n<h3>Format</h3>\r\nClick the drop-down list and choose the format in which text, numbers, and dates and times are displayed.\r\n<h3>Decimal Places</h3>\r\nFor a field that holds numbers, open the Decimal Places drop-down list and choose how many numbers can appear to the right of the decimal point. This property affects how numbers and currency values are displayed, not their real value. Numbers are rounded to the nearest decimal point. The Auto option displays the number of decimal places permitted by the format you chose on the Format drop-down list.\r\n<h3>Input Mask</h3>\r\nFor Text and Date field types, this feature provides a template with punctuation marks to make entering the data easier. Telephone numbers, social security numbers, and other numbers that typically are entered along with dashes and parentheses are ideal candidates for an input mask (another ridiculous database term!). On the datasheet, blank spaces appear where the numbers go, and the punctuation marks stand at the ready to receive numbers.\r\n\r\n[caption id=\"attachment_259209\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259209 size-full\" src=\"//sg.cdnki.com/how-to-open-field-properties-in-access---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzL29mZmljZS0yMDE5LWFjY2Vzcy1pbnB1dC1tYXNrcy5qcGc=.webp\" alt=\"Access Input Mask\" width=\"535\" height=\"173\" /> Input masks make data entry easier.[/caption]\r\n\r\n \r\n\r\nIn the Input Mask text box, enter a <strong>0</strong> where numbers go and enter the punctuation marks where they go. For example, enter (000) 000-0000 or 000/000-0000 to enter an input mask for a telephone number. You can also create input masks by clicking the three dots beside the Input Mask text box. Doing so opens the Input Mask Wizard dialog box, where you can fashion a very sophisticated input mask.\r\n<h3>Caption</h3>\r\nIf the field you're working on has a cryptic or hard-to-understand name, enter a more descriptive name in the Caption text box. The value in the Caption property appears as the column heading in Datasheet view, as a label on forms, and on reports in place of the field name. People entering data understand what to enter after reading the descriptive caption.\r\n<h3>Default Value</h3>\r\nWhen you know that the majority of records require a certain value, number, or abbreviation, enter it in the Default Value text box. That way, you save yourself the trouble of entering the value, number, or abbreviation most of the time because the default value appears already in each record when you enter it. You can always override the default value by entering something different.\r\n<h3>Validation Rule</h3>\r\nAs long as you know your way around operators and Boolean expressions, you can establish a rule for entering data in a field. For example, you can enter an expression that requires dates to be entered in a certain time frame. Or you can require currency figures to be above or below a certain value. To establish a validation rule, enter an expression in the Validation Rule text box. To use dates in an expression, the dates must be enclosed by number signs (#). Here are some examples of validation rules:\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td>>1000</td>\r\n<td>The value you enter must be over 1,000.</td>\r\n</tr>\r\n<tr>\r\n<td><1000</td>\r\n<td>The value you enter must be less than 1,000.</td>\r\n</tr>\r\n<tr>\r\n<td>>=10</td>\r\n<td>The value you enter must be greater than or equal to ten.</td>\r\n</tr>\r\n<tr>\r\n<td><>0</td>\r\n<td>The value you enter cannot be zero.</td>\r\n</tr>\r\n<tr>\r\n<td>>=#1/1/2019#</td>\r\n<td>The date you enter must be January 1, 2019, or later.</td>\r\n</tr>\r\n<tr>\r\n<td>>=#1/1/2019# And <#1/1/2020#</td>\r\n<td>The date you enter must be in the year 2019.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\nTo get help forming expressions, click the three dots beside the Validation Rule text box to open the Expression Builder and build an expression there. Try clicking the Help button in the Expression Builder dialog box. Doing so opens the Access Help program, where you can get advice about building expressions.\r\n\r\n[caption id=\"attachment_259208\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259208 size-full\" src=\"//sg.cdnki.com/how-to-open-field-properties-in-access---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzL29mZmljZS0yMDE5LWFjY2Vzcy12YWxpZGF0aW9uLXJ1bGUuanBn.webp\" alt=\"Access validation rule\" width=\"535\" height=\"399\" /> Creating a validation rule.[/caption]\r\n\r\n \r\n<h3>Validation Text</h3>\r\nIf someone enters data that violates a validation rule that you enter in the Validation Rule text box, Access displays a standard error message. The message reads, “One or more values are prohibited by the validation rule set for [this field]. Enter a value that the expression for this field can accept.” If this message is too cold and impersonal for you, you can create a message of your own for the error message dialog box. Enter your friendly message in the Validation Text text box.\r\n<h3>Required</h3>\r\nBy default, no entry has to be made in a field, but if you choose Yes instead of No in the Required box and you fail to make an entry in the field, a message box tells you to be sure to make an entry.\r\n<h3>Allow Zero Length</h3>\r\nThis property allows you to enter zero-length strings in a field. A <em>zero-length string</em> — two quotation marks with no text or spaces between them (“”) — indicates that no value exists for a field. To see how zero-length strings work, suppose that your database table calls for entering email addresses. If you didn’t know whether one person has an email address, you would leave the E-Mail Address field blank. If, however, you knew that the person didn’t have an email address, you could indicate as much by entering a zero-length string. Choose Yes on the drop-down list to permit zero-length strings to be entered in the field.\r\n<h3>Indexed</h3>\r\nThis property indicates whether the field has been indexed. Indexes make sorting a field and searching through a field go faster. The word <em>No</em> appears in this text box if the field has not been indexed.\r\n<h3>Unicode Expression</h3>\r\nChoose Yes from the Unicode Expression drop-down list if you want to compress data that is now stored in Unicode format. Storing data this way saves on disk space, and you probably don't want to change this property.\r\n<h3>Smart Tags</h3>\r\nIf you intend to enter Smart Tags in the field, indicate which kind you enter by clicking the three dots next to the Smart Tags box and choosing an option in the Action Tags dialog box.\r\n<h3>Text Align</h3>\r\nThis property determines how the text is aligned in a column or on a form or report. Select General to let Access determine the alignment, or select Left, Right, Center, or Distribute.\r\n<h3>Text Format</h3>\r\nAvailable on Long Text fields, this drop-down list lets you choose to allow rich text in the field. With this property set to Rich Text, you can make different words bold, italic, underline, and change font sizes and colors. Set it to Plain Text for plain, boring text with no formatting.\r\n<h3>Append Only</h3>\r\nAvailable on Long Text fields, this property lets you add data only to a Long Text field to collect a history of comments.\r\n<h3>Show Date Picker</h3>\r\nThis property is available on Date/Time fields. Choose For Dates to place a button next to the column that data-entry clerks can click to open a calendar and select a date instead of typing numbers.\r\n<h3>IME Mode/IME Sentence mode</h3>\r\nThese options are for converting characters and sentences from East Asian versions of Access.\r\n<h2 id=\"tab2\" >Creating a lookup data-entry list in MS Access</h2>\r\nPerhaps the best way to make sure that data is entered correctly is to create a data-entry drop-down list. That way, anyone entering the data in your database table can do so by choosing an item from the list, not by typing it in. This method saves time and prevents invalid data from being entered. Access offers two ways to create the drop-down list:\r\n<ul>\r\n \t<li><strong>Create the list by entering the items yourself:</strong> Go this route when you’re dealing with a finite list of items that never change.</li>\r\n \t<li><strong>Get the items from another database table:</strong> Go this route to get items from a column in another database table. This way, you can choose from an ever-expanding list of items. When the number of items in the other database table changes, so does the number of items in the drop-down list because the items come from the other database table. This is a great way to get items from a primary key field in another table.</li>\r\n</ul>\r\n[caption id=\"attachment_259210\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259210 size-full\" src=\"//sg.cdnki.com/how-to-open-field-properties-in-access---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzL29mZmljZS0yMDE5LWFjY2Vzcy1sb29rLXVwLWxpc3QuanBn.webp\" alt=\"Access lookup-list\" width=\"535\" height=\"253\" /> A so-called lookup list.[/caption]\r\n\r\n \r\n<h3>Creating a drop-down list on your own</h3>\r\nFollow these steps to create a drop-down, or <em>lookup,</em> list with entries you type:\r\n<ol>\r\n \t<li>In Design view, click the field that needs a drop-down list.</li>\r\n \t<li>Open the Data Type drop-down list and choose Lookup Wizard, the last option in the list.<strong>\r\n\r\n</strong>The Lookup Wizard dialog box appears.</li>\r\n \t<li>Select the second option, I Will Type in the Values That I Want, and click the Next button.</li>\r\n \t<li>Under Col1 in the next dialog box, enter each item you want to appear in the drop-down list; then click the Next button.<strong>\r\n\r\n</strong>You can create a multicolumn list by entering a number in the Number of Columns text box and then entering items for the list.</li>\r\n \t<li>Enter a name for the field, if necessary, and click the Finish button.\r\n\r\nSwitch to Datasheet view and open the drop-down list in the field to make sure that it displays properly.</li>\r\n</ol>\r\nTo remove a lookup list from a field, select the field, go to the Lookup tab in the Design view window, open the Display Control drop-down list, and choose Text Box.\r\n<p class=\"article-tips tip\">To see what’s on a drop-down list, select the field for which you created the list, switch to Design view, and select the Lookup tab in the Field Properties pane. You can edit the list by editing or removing items in the Row Source text box. Be sure that a semi-colon (;) appears between each item.</p>\r\n\r\n\r\n[caption id=\"attachment_259211\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259211 size-full\" src=\"//sg.cdnki.com/how-to-open-field-properties-in-access---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzL29mZmljZS0yMDE5LWFjY2Vzcy1sb29rdXAtZmllbGQtcHJvcGVydGllcy5qcGc=.webp\" alt=\"Access lookup field properties\" width=\"535\" height=\"201\" /> Lookup field properties.[/caption]\r\n<h3>Getting list items from a database table</h3>\r\nBefore you can get list items from another database table, you might want to define a relationship between the tables; it’s not required, but it’s recommended. Follow these steps to get items in a drop-down list from another database table:\r\n<ol>\r\n \t<li>In Design view, click the field that needs a list, open the Data Type drop-down list, and choose Lookup Wizard.<strong>\r\n\r\n</strong>The Lookup Wizard dialog box appears.</li>\r\n \t<li>Select the first option, I Want the Lookup Field to Get the Values from Another Table or Query, and click Next.<strong>\r\n\r\n</strong>You see a list of tables in your database.</li>\r\n \t<li>Select the table with the data you need and click the Next button.<strong>\r\n\r\n</strong>The dialog box shows you a list of available fields in the table.</li>\r\n \t<li>Select the field where the data for your list is stored.</li>\r\n \t<li>Click the > button.<strong>\r\n\r\n</strong>The name of the list appears on the right side of the dialog box, under Selected Fields.</li>\r\n \t<li>Click the Next button.\r\n\r\nNormally, lists are displayed in ascending order, but you can select a field and click the Ascending button to reverse the order of the list. (Note that the button turns into the Descending button.)</li>\r\n \t<li>Click the Finish button.<strong>\r\n\r\n</strong>If you’re so inclined, you can change the width of the list before clicking Finish, but you can always do that on the datasheet.</li>\r\n</ol>\r\n<p class=\"article-tips tip\">Suppose that you obtain the items from the wrong field or wrong database table. To fix that problem, select the field for which you created the list, and in Design view, select the Lookup tab. Choose Text Box instead of Combo Box on the Display Control drop-down list and start all over.</p>","description":"Unfortunately, entering the data in an Access database table is one of the most tedious activities known to humankind. And because the activity is so dull, people are prone to make mistakes when they enter data in an <a href=\"//www.dummies.com/software/microsoft-office/access/how-access-2019-works-and-how-you-work-with-it/\">Access 2019</a> database table. One way to cut down on mistakes is to take advantage of the Field Properties settings on the General tab in the Design view window.\r\n\r\n[caption id=\"attachment_259207\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259207 size-full\" src=\"//www.dummies.com/wp-content/uploads/office-2019-access-field-properties.png\" alt=\"Access field properties\" width=\"535\" height=\"184\" /> Establishing field properties.[/caption]\r\n\r\n \r\n\r\nThese properties determine what can and can’t be entered in the different fields of a database table. Some of the settings are invaluable. The Field Size property, for example, determines how many characters can be entered in a field. In a State field where two-letter state abbreviations are to be entered, make the Field Size property 2 to be certain that no one enters more than two characters. If the majority of people you’re tracking in an address database live in New York, enter NY in the Default Value property. That way, you spare data-entry clerks from having to enter NY the majority of the time. They won’t have to enter it because NY is already there.\r\n\r\nThe Lookup tab in the Field Properties part of the Design view window is for creating a data-entry drop-down list. It, too, is invaluable. If you happen to know that only four items can be entered in a field, create a drop-down list with the four items. That way, data-entry clerks can choose from a list of four valid items instead of having to enter the data themselves and perhaps enter it incorrectly.\r\n<h2 id=\"tab1\" >A look at MS Access Field Properties settings</h2>\r\nEspecially if yours is a large database, you’re encouraged to study the field properties carefully and make liberal use of them. The Field Properties settings safeguard data from being entered incorrectly. Following is a description of the different properties (listed here in the order in which they appear in the Design view window) and instructions for using them wisely. Which properties you can assign to a <a href=\"//www.dummies.com/software/microsoft-office/access/field-types-and-uses-in-access-2019-databases/\">field in Access</a> depends on which data type the field was assigned.\r\n<h3>Field Size</h3>\r\nIn the Field Size box for Text fields, enter the maximum number of characters that can be entered in the field. Suppose that the field you’re dealing with is ZIP code, and you want to enter five-number ZIP codes. By entering <strong>5</strong> in the Field Size text box, only five characters can be entered in the field. A sleepy data-entry clerk couldn’t enter a six-character ZIP code by accident.\r\n\r\nFor Number fields, select a value for the field size from the drop-down list. The table below describes these field sizes.\r\n<table><caption>Access Numeric Field Sizes</caption>\r\n<thead>\r\n<tr>\r\n<td>Field Size</td>\r\n<td>Description</td>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td>Byte</td>\r\n<td>An integer that holds values from 0–255.</td>\r\n</tr>\r\n<tr>\r\n<td>Integer</td>\r\n<td>An integer that holds values from –32,768– +32,767.</td>\r\n</tr>\r\n<tr>\r\n<td>Long Integer</td>\r\n<td>An integer that holds values from –2,147,483,648– +2,147,483,647.</td>\r\n</tr>\r\n<tr>\r\n<td>Single</td>\r\n<td>A floating point number that holds large values up to 7 significant digits.</td>\r\n</tr>\r\n<tr>\r\n<td>Double</td>\r\n<td>A floating point number that holds large values up to 15 significant digits.</td>\r\n</tr>\r\n<tr>\r\n<td>Replication ID^*</td>\r\n<td>A globally unique identifier (GUID) required for replication; this number is generated randomly.</td>\r\n</tr>\r\n<tr>\r\n<td>Decimal</td>\r\n<td>A number with defined decimal precision. The default precision is 0, but you can set the scale up to 28.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<em>^*Not supported by the <code>.accdb</code> file format.</em>\r\n<p class=\"article-tips tech\">The Single, Double, and Decimal field size options hold different ranges of numbers. For now, if you need to store numbers after the decimal point, choose the Double field size so that you cover most situations.</p>\r\n\r\n<h3>Format</h3>\r\nClick the drop-down list and choose the format in which text, numbers, and dates and times are displayed.\r\n<h3>Decimal Places</h3>\r\nFor a field that holds numbers, open the Decimal Places drop-down list and choose how many numbers can appear to the right of the decimal point. This property affects how numbers and currency values are displayed, not their real value. Numbers are rounded to the nearest decimal point. The Auto option displays the number of decimal places permitted by the format you chose on the Format drop-down list.\r\n<h3>Input Mask</h3>\r\nFor Text and Date field types, this feature provides a template with punctuation marks to make entering the data easier. Telephone numbers, social security numbers, and other numbers that typically are entered along with dashes and parentheses are ideal candidates for an input mask (another ridiculous database term!). On the datasheet, blank spaces appear where the numbers go, and the punctuation marks stand at the ready to receive numbers.\r\n\r\n[caption id=\"attachment_259209\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259209 size-full\" src=\"//www.dummies.com/wp-content/uploads/office-2019-access-input-masks.jpg\" alt=\"Access Input Mask\" width=\"535\" height=\"173\" /> Input masks make data entry easier.[/caption]\r\n\r\n \r\n\r\nIn the Input Mask text box, enter a <strong>0</strong> where numbers go and enter the punctuation marks where they go. For example, enter (000) 000-0000 or 000/000-0000 to enter an input mask for a telephone number. You can also create input masks by clicking the three dots beside the Input Mask text box. Doing so opens the Input Mask Wizard dialog box, where you can fashion a very sophisticated input mask.\r\n<h3>Caption</h3>\r\nIf the field you're working on has a cryptic or hard-to-understand name, enter a more descriptive name in the Caption text box. The value in the Caption property appears as the column heading in Datasheet view, as a label on forms, and on reports in place of the field name. People entering data understand what to enter after reading the descriptive caption.\r\n<h3>Default Value</h3>\r\nWhen you know that the majority of records require a certain value, number, or abbreviation, enter it in the Default Value text box. That way, you save yourself the trouble of entering the value, number, or abbreviation most of the time because the default value appears already in each record when you enter it. You can always override the default value by entering something different.\r\n<h3>Validation Rule</h3>\r\nAs long as you know your way around operators and Boolean expressions, you can establish a rule for entering data in a field. For example, you can enter an expression that requires dates to be entered in a certain time frame. Or you can require currency figures to be above or below a certain value. To establish a validation rule, enter an expression in the Validation Rule text box. To use dates in an expression, the dates must be enclosed by number signs (#). Here are some examples of validation rules:\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td>>1000</td>\r\n<td>The value you enter must be over 1,000.</td>\r\n</tr>\r\n<tr>\r\n<td><1000</td>\r\n<td>The value you enter must be less than 1,000.</td>\r\n</tr>\r\n<tr>\r\n<td>>=10</td>\r\n<td>The value you enter must be greater than or equal to ten.</td>\r\n</tr>\r\n<tr>\r\n<td><>0</td>\r\n<td>The value you enter cannot be zero.</td>\r\n</tr>\r\n<tr>\r\n<td>>=#1/1/2019#</td>\r\n<td>The date you enter must be January 1, 2019, or later.</td>\r\n</tr>\r\n<tr>\r\n<td>>=#1/1/2019# And <#1/1/2020#</td>\r\n<td>The date you enter must be in the year 2019.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\nTo get help forming expressions, click the three dots beside the Validation Rule text box to open the Expression Builder and build an expression there. Try clicking the Help button in the Expression Builder dialog box. Doing so opens the Access Help program, where you can get advice about building expressions.\r\n\r\n[caption id=\"attachment_259208\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259208 size-full\" src=\"//www.dummies.com/wp-content/uploads/office-2019-access-validation-rule.jpg\" alt=\"Access validation rule\" width=\"535\" height=\"399\" /> Creating a validation rule.[/caption]\r\n\r\n \r\n<h3>Validation Text</h3>\r\nIf someone enters data that violates a validation rule that you enter in the Validation Rule text box, Access displays a standard error message. The message reads, “One or more values are prohibited by the validation rule set for [this field]. Enter a value that the expression for this field can accept.” If this message is too cold and impersonal for you, you can create a message of your own for the error message dialog box. Enter your friendly message in the Validation Text text box.\r\n<h3>Required</h3>\r\nBy default, no entry has to be made in a field, but if you choose Yes instead of No in the Required box and you fail to make an entry in the field, a message box tells you to be sure to make an entry.\r\n<h3>Allow Zero Length</h3>\r\nThis property allows you to enter zero-length strings in a field. A <em>zero-length string</em> — two quotation marks with no text or spaces between them (“”) — indicates that no value exists for a field. To see how zero-length strings work, suppose that your database table calls for entering email addresses. If you didn’t know whether one person has an email address, you would leave the E-Mail Address field blank. If, however, you knew that the person didn’t have an email address, you could indicate as much by entering a zero-length string. Choose Yes on the drop-down list to permit zero-length strings to be entered in the field.\r\n<h3>Indexed</h3>\r\nThis property indicates whether the field has been indexed. Indexes make sorting a field and searching through a field go faster. The word <em>No</em> appears in this text box if the field has not been indexed.\r\n<h3>Unicode Expression</h3>\r\nChoose Yes from the Unicode Expression drop-down list if you want to compress data that is now stored in Unicode format. Storing data this way saves on disk space, and you probably don't want to change this property.\r\n<h3>Smart Tags</h3>\r\nIf you intend to enter Smart Tags in the field, indicate which kind you enter by clicking the three dots next to the Smart Tags box and choosing an option in the Action Tags dialog box.\r\n<h3>Text Align</h3>\r\nThis property determines how the text is aligned in a column or on a form or report. Select General to let Access determine the alignment, or select Left, Right, Center, or Distribute.\r\n<h3>Text Format</h3>\r\nAvailable on Long Text fields, this drop-down list lets you choose to allow rich text in the field. With this property set to Rich Text, you can make different words bold, italic, underline, and change font sizes and colors. Set it to Plain Text for plain, boring text with no formatting.\r\n<h3>Append Only</h3>\r\nAvailable on Long Text fields, this property lets you add data only to a Long Text field to collect a history of comments.\r\n<h3>Show Date Picker</h3>\r\nThis property is available on Date/Time fields. Choose For Dates to place a button next to the column that data-entry clerks can click to open a calendar and select a date instead of typing numbers.\r\n<h3>IME Mode/IME Sentence mode</h3>\r\nThese options are for converting characters and sentences from East Asian versions of Access.\r\n<h2 id=\"tab2\" >Creating a lookup data-entry list in MS Access</h2>\r\nPerhaps the best way to make sure that data is entered correctly is to create a data-entry drop-down list. That way, anyone entering the data in your database table can do so by choosing an item from the list, not by typing it in. This method saves time and prevents invalid data from being entered. Access offers two ways to create the drop-down list:\r\n<ul>\r\n \t<li><strong>Create the list by entering the items yourself:</strong> Go this route when you’re dealing with a finite list of items that never change.</li>\r\n \t<li><strong>Get the items from another database table:</strong> Go this route to get items from a column in another database table. This way, you can choose from an ever-expanding list of items. When the number of items in the other database table changes, so does the number of items in the drop-down list because the items come from the other database table. This is a great way to get items from a primary key field in another table.</li>\r\n</ul>\r\n[caption id=\"attachment_259210\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259210 size-full\" src=\"//www.dummies.com/wp-content/uploads/office-2019-access-look-up-list.jpg\" alt=\"Access lookup-list\" width=\"535\" height=\"253\" /> A so-called lookup list.[/caption]\r\n\r\n \r\n<h3>Creating a drop-down list on your own</h3>\r\nFollow these steps to create a drop-down, or <em>lookup,</em> list with entries you type:\r\n<ol>\r\n \t<li>In Design view, click the field that needs a drop-down list.</li>\r\n \t<li>Open the Data Type drop-down list and choose Lookup Wizard, the last option in the list.<strong>\r\n\r\n</strong>The Lookup Wizard dialog box appears.</li>\r\n \t<li>Select the second option, I Will Type in the Values That I Want, and click the Next button.</li>\r\n \t<li>Under Col1 in the next dialog box, enter each item you want to appear in the drop-down list; then click the Next button.<strong>\r\n\r\n</strong>You can create a multicolumn list by entering a number in the Number of Columns text box and then entering items for the list.</li>\r\n \t<li>Enter a name for the field, if necessary, and click the Finish button.\r\n\r\nSwitch to Datasheet view and open the drop-down list in the field to make sure that it displays properly.</li>\r\n</ol>\r\nTo remove a lookup list from a field, select the field, go to the Lookup tab in the Design view window, open the Display Control drop-down list, and choose Text Box.\r\n<p class=\"article-tips tip\">To see what’s on a drop-down list, select the field for which you created the list, switch to Design view, and select the Lookup tab in the Field Properties pane. You can edit the list by editing or removing items in the Row Source text box. Be sure that a semi-colon (;) appears between each item.</p>\r\n\r\n\r\n[caption id=\"attachment_259211\" align=\"aligncenter\" width=\"535\"]<img class=\"wp-image-259211 size-full\" src=\"//www.dummies.com/wp-content/uploads/office-2019-access-lookup-field-properties.jpg\" alt=\"Access lookup field properties\" width=\"535\" height=\"201\" /> Lookup field properties.[/caption]\r\n<h3>Getting list items from a database table</h3>\r\nBefore you can get list items from another database table, you might want to define a relationship between the tables; it’s not required, but it’s recommended. Follow these steps to get items in a drop-down list from another database table:\r\n<ol>\r\n \t<li>In Design view, click the field that needs a list, open the Data Type drop-down list, and choose Lookup Wizard.<strong>\r\n\r\n</strong>The Lookup Wizard dialog box appears.</li>\r\n \t<li>Select the first option, I Want the Lookup Field to Get the Values from Another Table or Query, and click Next.<strong>\r\n\r\n</strong>You see a list of tables in your database.</li>\r\n \t<li>Select the table with the data you need and click the Next button.<strong>\r\n\r\n</strong>The dialog box shows you a list of available fields in the table.</li>\r\n \t<li>Select the field where the data for your list is stored.</li>\r\n \t<li>Click the > button.<strong>\r\n\r\n</strong>The name of the list appears on the right side of the dialog box, under Selected Fields.</li>\r\n \t<li>Click the Next button.\r\n\r\nNormally, lists are displayed in ascending order, but you can select a field and click the Ascending button to reverse the order of the list. (Note that the button turns into the Descending button.)</li>\r\n \t<li>Click the Finish button.<strong>\r\n\r\n</strong>If you’re so inclined, you can change the width of the list before clicking Finish, but you can always do that on the datasheet.</li>\r\n</ol>\r\n<p class=\"article-tips tip\">Suppose that you obtain the items from the wrong field or wrong database table. To fix that problem, select the field for which you created the list, and in Design view, select the Lookup tab. Choose Text Box instead of Combo Box on the Display Control drop-down list and start all over.</p>","blurb":"","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Peter Weverka</b> is a veteran <i>For Dummies</i> author who has written about a wide variety of applications. Along with two bestselling editions of <i>Office All-in-One For Dummies</i>, Peter has written <i>PowerPoint All-in-One For Dummies</i> and <i>Microsoft Money For Dummies</i>.</p>","hasArticle":false,"_links":{"self":"//dummies-api.dummies.com/v2/authors/9034"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"//dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"A look at MS Access Field Properties settings","target":"#tab1"},{"label":"Creating a lookup data-entry list in MS Access","target":"#tab2"}],"relatedArticles":{"fromBook":[{"articleId":259408,"title":"What Is Outlook?","slug":"what-is-outlook","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/259408"}},{"articleId":259402,"title":"Detecting and Correcting Errors in Excel 2019 Formulas","slug":"detecting-and-correcting-errors-in-excel-2019-formulas","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/259402"}},{"articleId":259390,"title":"How to Touch Up a Picture Using Office 2019 Tools","slug":"how-to-touch-up-a-picture-using-office-2019-tools","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/259390"}},{"articleId":259292,"title":"How Excel Formulas Work","slug":"how-excel-formulas-work","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/259292"}},{"articleId":259285,"title":"Office 2019 Chart Tricks for the Daring and Heroic","slug":"office-2019-chart-tricks-for-the-daring-and-heroic","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/259285"}}],"fromCategory":[{"articleId":294664,"title":"Windows 365 For Dummies Cheat Sheet","slug":"windows-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/294664"}},{"articleId":291623,"title":"Office 2021 For Macs For Dummies Cheat Sheet","slug":"office-2021-for-macs-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/291623"}},{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/289688"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281801,"slug":"office-2019-all-in-one-for-dummies","isbn":"9781119513278","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"//www.amazon.com/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"//www.amazon.ca/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"//www.tkqlhce.com/click-9208661-13710633?url=//www.chapters.indigo.ca/en-ca/books/product/1119513278-item.html&cjsku=978111945484","gb":"//www.amazon.co.uk/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"//www.amazon.de/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"//www.dummies.com/wp-content/uploads/office-2019-all-in-one-for-dummies-cover-9781119513278-203x255.jpg","width":203,"height":255},"title":"Office 2019 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran tech writer and long-time <i>For Dummies</i> author. Among his credits are <i>Office 2016 All-in-One For Dummies</i> and <i>Windows 10 For Seniors For Dummies</i>, both top sellers in their respective categories. </p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Peter Weverka</b> is a veteran <i>For Dummies</i> author who has written about a wide variety of applications. Along with two bestselling editions of <i>Office All-in-One For Dummies</i>, Peter has written <i>PowerPoint All-in-One For Dummies</i> and <i>Microsoft Money For Dummies</i>.</p>","hasArticle":false,"_links":{"self":"//dummies-api.dummies.com/v2/authors/9034"}}],"_links":{"self":"//dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513278&quot;]}]\" id=\"du-slot-63221a9d7f0cc\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513278&quot;]}]\" id=\"du-slot-63221a9d7f928\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":259206},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2022-11-21T10:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"//cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"\" ? \"//sb\" : \"//b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"//sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"//zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for //www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'//static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"//www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"},{"collectionId":287567,"title":"For the Unabashed Hippie","hasSubCategories":false,"url":"/collection/for-the-unabashed-hippie-287567"},{"collectionId":295430,"title":"Have a Beautiful (and Tasty) Thanksgiving","hasSubCategories":false,"url":"/collection/have-a-wonderful-thanksgiving-295430"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/general-microsoft/ms-access-field-properties-for-making-sure-that-data-entries-are-accurate-259206/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"general-microsoft","article":"ms-access-field-properties-for-making-sure-that-data-entries-are-accurate-259206"},"fullPath":"/article/technology/software/microsoft-products/general-microsoft/ms-access-field-properties-for-making-sure-that-data-entries-are-accurate-259206/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"sfmcState":{"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}