What is the difference between format and input mask attributes in table fields

The difference between format and input mask attributes in table fields is: 1. Different applicability, mask is used for input, format is used for display; 2. Different functions, mask can be used to protect data , you can also set a fixed format for input, and the format is mainly used to set the type of data, which determines whether the execution of the query is valid.

The operating environment of this article: Windows 7 system, Dell G3 computer.

The difference between "format" and "input mask"

1. Different applicability

The mask is used for input, and the format is used for display.

2. Different functions

Mask can be used to protect data, and a fixed format can also be set for input.

Format is mainly used to set the type of data. It determines whether the execution of the query is valid, especially on the join between tables. When the types do not match, the query will not be executed.

Extended information

The mask in access displays the editing characters that guide data input, restricting the type and form of data entered in the field.

Masks are used when designing tables, and their effects are obvious, such as when applying rules such as ID cards and passwords.

1. For the input mask of "Only 4 digits can be entered", fill in "0000".

2. For the input mask of "Only 4 digits or symbols can be entered", fill in "AAAA".

3. For the input mask of "Only enter 4 digits or spaces", fill in "9999" or "

For more related knowledge, please visitPHP Chinese website

The above is the detailed content of What is the difference between format and input mask attributes in table fields. For more information, please follow other related articles on the PHP Chinese website!