Validation Rule needed Access 2003

[Guest]

Hey guys and gals,

I'm having a small problem with my Access database.
I'm setting up a data access page so people can goto the HTM page and input
data. I've run into 2 problems in doing this.

1. No matter what my validation rule is set to, the data access page always
says there is a problem with it. (The validation text keeps popping up)
2. When I enter the data in through the table, it works perfectly.

Bascially what I'm doing is the dreaded phone number. This will only include
North American phone numbers to be displayed as 555-555-5555. I want this
format to show in the table as well as the data access page. Also if a user
enters a number that is less then 10 digits, it spews back and error. Any
ideas??

Thanks to all who can help!

 

[Guest]

You need an input mask not validation.

 

[Guest]

Actually I don't because if a Validationrule is in place then a input mask is
not needed. For others that are looking at this, this is what I have in place
now:

Data Type: Text
Field Size: 12
Validation Rule: Like "###-###-####"

This works perfectly when entering data into the table directly. But when I
access this through a HTM Page, validation errors keep popping up. I thought
both of these were linked, I guess not.

 

[Guest]

Sorry, do not know anything about HTM Page.

Actually I don't because if a Validationrule is in place then a input mask is
not needed. For others that are looking at this, this is what I have in place
now:

Data Type: Text
Field Size: 12
Validation Rule: Like "###-###-####"

This works perfectly when entering data into the table directly. But when I
access this through a HTM Page, validation errors keep popping up. I thought
both of these were linked, I guess not.