specific Number

[Guest]

I have set up a database containing part numbers. the part number is always
three numbers then a dash then five numbers. eg " 123-45678".
How do I make my part number field in my table only except this format and
how do I get a query to only except this format.

 

[Guest]

Open the table in design view, and define an input mask to the filed
999-99999

 

[Arvin Meyer [MVP]]

Almost. Using 9's will not require the entry of a number, using 0's will. So
the input mask should read:

000\-00000
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I did try 999\-99999

And I tried it again just in case, and I can't enter any value beside numbers

--
I hope that helped
Good luck

Almost. Using 9's will not require the entry of a number, using 0's will. So
the input mask should read:

000\-00000
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer [MVP]]

I did try 999\-99999

And I tried it again just in case, and I can't enter any value beside

numbers

True, but you are free to only enter some of the numbers. For instance, with
9's, 123-456 is a valid entry.

If you remember, the poster stated the number is always 3digits-5digits
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access