answersLogoWhite

0


Best Answer

An input mask refers to controlling the input that a user is going to provide.

For example, if you were going to ask for a person's phone number, and you know the format of the phone number is going to be (xxx) xxx-xxxx, then you would set an input mask forcing the input to be in that format.

A zip code, for example, is 5 or 9 characters in the U.S..... either 12345 or 12345-6789.

Therefore, you would use an input mask that looked like xxxxx | xxxxx-xxxx

This controls the user's input so that less validation is required later.

Input masks are mostly used to validate input that has a strict pattern that never changes. With Access validation rules you can validate more complex patterns.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is input mask in a database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is input mask as used in database?

An input mask is a pattern or template used to control the input of data into a database field. It defines the acceptable format for data entry, such as phone numbers, dates, or social security numbers. Input masks help ensure data consistency and accuracy by guiding users to input data in a specific format.


What is format mask and input mask in database?

Input mask is a tool which allows the database creator to set a certain format to a certain field to show what can be entered into that particular field. You can add input masks to table fields, queries, and to form and report. Input masks provide a set format for data entry in a field by using characters and symbols. When you apply an input mask to a field, anyone who inputs data in that field must follow the specific pattern defined by the input mask. For example, if the database user enters a phone number and does not follow then input mask, In this case the input mask could be 0000 000 0000 (0 stands for number 0-9) the user will be unable to save the data until the number is entered as the input mask format. Input masks provide a large amount of data validation and prevent users from entering invalid data (such as a phone number in a date field). Input masks can also help ensure that users enter data in a consistent way. This would also improve the data that is being inputted making sure it is accurate,easier to find and understand if it's all in one the same format. Im doing this for ICT stuff lucky i found this question to answer as im bored and doing it noww Lol


What is a series of symbols that defines how a format displays?

A mask or input mask.


Why is input destructive and output non destructive in database?

WANT THE ANSWER TO THIS QUESTION


How do you insert value to a dropdownlist from textbox input php?

Store the textbox input in a database using a html form prefarably. Using a loop get all the textbox input from database and use print/echo to show them in a dropdown.


What is A form of database specification that indicates all the parameters for data storge that are then input to database implementation?

Physical


In a spreadsheet input cells correspond conceptually to?

database fields


how to create a saving database(even if the page is refreshed)?

g<br>use the query: $database = [^/s]?get id="input"


What is The symbol in an input mask that is replaced as you type data into the field?

placeholder


What is a user database?

A user database is a system that more than 1 person can access and gain information from. Multiple users can input and store data in these database systems.


What is a sentence with the word input?

The program requires user input to generate the final output.


How do you save voice in database access?

I don't know but i need that information about how to store a voice as input for sql server 2005 and retrieve that using current input of voice.., I mean how two compare a already stored voice in database with given new input voice..,