Search results
Results from the WOW.Com Content Network
You can help people enter data correctly into your Access desktop database by providing input masks for fields that contain data that is always formatted a certain way. For example, you can use an input mask to make sure that people enter correctly formatted phone numbers into a phone number field.
You can use the Validation Rule property and the Validation Text property of a form control to validate data that is input to that control and to help users who input data that is not valid.
When you want to constrain entry of date and time in a specific format, use an input mask. For example, if you applied an input mask to enter dates in the European format, someone entering data in your database will not be able to enter dates in other formats.
In this article. Understand date and time fields. Add a date and time field in Datasheet View. Add a date and time field in Design view. Set date and time field properties. Delete a date and time field. Date and time field property reference. Understand date and time fields.
You define an input mask when you need to control how users enter data in the field. For more information about using input masks, see the article Create an input mask to enter field or control values in a specific format. Caption. Specifies the name of your Short Text field.
In this article. Overview. When to use which data type. Field size property. Data types in relationships and joins. Data type reference. Overview. Data types can seem confusing for example, if a field's data type is Short Text, it can store data that consists of either text or numerical characters.
An input mask forces you to enter data in a predefined format. The masks appear when you select a field in a table or a control on a form. For example, suppose you click a Date field and see this set of characters: MMM-DD-YYYY.
When you have defined an input mask and set the Format property for the same data, the Format property takes precedence when the data is displayed and the input mask is ignored.
Searches based on an input mask or format . Find operations can search for data or the format applied to data. For example, you can search for Feb in fields formatted with a Date/Time input mask. This option remains unavailable until you search on a field with either a format or input mask applied.
You can also create an input mask for a text box control bound to a field by setting the InputMask property for the field in the form's underlying table or query. If the field is dragged to a form from the field list, the field's input mask is inherited by the text box control.
In a form you can use the date picker and the input mask to enter a date with the larger range, but not the fractional precision for nanoseconds. Expression Support The Date/Time Extended data type supports SQL Aggregate Functions and expression evaluation.