G
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!
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!