What are the differences between formatting and input mask properties in table fields
This article mainly introduces the differences between the format in the table field and the input mask attribute, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it.
The differences between the format and the input mask attributes in the table field are: 1, the applicability is different, the mask is used for input, and the format is used for display; 2, the function is different, the mask can be used to protect data, and 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 effective.
The difference between format and input Mask
1. Different applicability
The mask is for input and the format is for display.
2. Different functions
Masks can be used to protect data and can be entered in a fixed format.
The 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 the table and the table, and the query cannot be executed when the type does not match.
Extended data
The mask in access displays the editing characters that guide the data input, limiting the type and form of data entered in the field.
Masks are used in table design, and its function is obvious, such as ID card, password and other rules.
1. Fill in "0000" for the input mask of "only 4 digits".
2. The input mask of "only 4 digits or symbols can be entered" fill in "AAAA".
3. Enter only 4 digits or spaces. Fill in the input mask "9999" or "# #".
Thank you for reading this article carefully. I hope the article "what is the difference between the format in the table field and the input mask attribute" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!
