Question: If you want to force a user to enter data using a specific format, for example, to store a customer's phone number in a table

If you want to force a user to enter data using a specific format, for example, to store a customer's phone number in a table so that it is saved with parentheses around the area code and a dash before the last four digits, like (555)555-5555, what property type should you use?

		Validation Rule
		Validation Text
		Input Mask
		Format

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The variable resistor R in the circuit of Fig. 11.50 is adjusted until it absorbs the maximum average power. Find R and the maximum average power absorbed. -j100 2 100 2 100 2 100/0 V (+ j100 2 lle

Remaining Time: 1 hour, 59 minutes, 41 seconds. Question Completion Status QUESTION 1 3 points if there are 2 primary keys identified in a table that indicates a cor primary Kay True False QUESTION 2...

--Create a Java application called FindElement . This application will need a number of parameters: Scanner class variable, called keyboard, for inputting information Integer variables, called...

***please look at the examples given to how the output should be thank you**** Create a Java application called FindElement . This application will need a number of parameters: Scanner class...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Any help with this would be greatly appreciated! An HR Payroll System Computers are great at storing and manipulating data. For this project, you will write code that keeps track of Human Resources...

REMINDERS and GRADING CRITERIA: This is an individual lab. Effort has been made to insure that this lab description is complete and consistent. That does not mean that you will not find errors or...

Since a Makefile is required for this lab, you must create the appropriate compile statements to create a lab3.o file, which would then create a lab3 executable. Graders will be downloading your...

The Person Class This class should go in a package called people. A person has first name last name email address Address and one or more PhoneNumbers (NOTE: A person can have any number of phone...

REA Homework #2 Pegasus Paper Products Pegasus Paper Products Inc. Your co-worker, Athletic Annie, was working on the database design project for Pegasus Paper Products (PPP) when she suffered a...

This project involved a hospital extension consisting of a nine-storey building and a service building for the power generator and water storage. The project was almost 3 years behind schedule and...

A diploid organism produces four gametes from one parent cell through the process of meiosis. Two gametes are found to have 6 chromosomes, one gamete is found to have 7 chromosomes and one gamete is...

Suppose a shipping compary required all applicants to lift 5 0 - pound bowes on and off a truck for an hour to test their strength and endurance. Suppose that resuited in the hiring of 5 0 of 1 0 0...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...