How do i format a text box to only accept numbers?

[bkeelane]

When validating form fields in front page i want to only allow numbers for
the person's phone number (without dashes). when i go into form field
validation i understand that i can change the input type to text, number or
integer but even if i change the type to one of those it still accepts
hyphens as a character. is there a way to disallow this? or is there a way
for format the 10 digit number as xxx-xxx-xxxx?

thanks
becky

 

[Thomas A. Rowe]

Set field validation to text, then check "Other" only and type in 0123456789

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[bkeelane]

thanks so much!!! i didn't realize it was that easy!

 

[bkeelane]

okay now i have another problem... the form is delivering the form results to
a csv file. We then import the records into an access database.
Is there a way to format the fields either in the csv file or in access to
be the correct format (for a ssn the format would be 111-11-1111). I would
leave it up to the applicants to enter this information in but i've tried
that and still get a deluge of ssn's not formatted correctly.

keep in mind that our access database already has records in it that are
formatted correctly (with the dashes) so i don't know if formatting a column
or group of cells in access (if that's even possible) would mess up the
records we already have saved.

also, is there a way to verify that the person has entered a valuable email
address? we have several applicants who just enter their screenname without
the domain.

thanks.

becky

 

[Thomas A. Rowe]

Instead of writing to a csv file, which not write directly to the an Access database on the web, and
you would have to format the data prior to it being inserted in the database or whenever you display
the data. You can not verify that a email address is valid, unless you send to it. Depending on what
you are doing, you have folks complete the form, submit, and then they must wait to receive an
email, which has a link back to your site, that they would click on, which then would confirm the
email address used at that point in time was a valid one.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================