Date format and requiring a field to be entered

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

How can I require that a text field on a form in Frontpage
utilize a date format? When I select Form Field
Properties for a text box, under Data type, I don't see a
Date option...what should I use to make sure data is
entered in date format?

Also, is there a way in Frontpage to require a field be
entered? I see the Validate button under form field
properties but I don't see where I can select that a field
is required when it is a text field.

My data is being stored in Access.

Thanks!
 
For the date:
Do not use one text box. Use three. One for Month, one for Day and One
for Year. Then validate them to be required a numbers. Then, when you write
the date to the database put those three numbers together as on record.

For the text box validation:
Select Validation under properties. Under Data Length select Required.

Mikeal
 
Thanks Mikeal! Very helpful. I can't believe with this
being a Microsoft product that there is not a date
format...seems silly to do it with three text
boxes...thanks for helping!
 
It's probably better to have it as three seperate fields anyway, just as it's better to have first & last names as sep. fields when you build a database.

JMO..

R.


| Thanks Mikeal! Very helpful. I can't believe with this
| being a Microsoft product that there is not a date
| format...seems silly to do it with three text
| boxes...thanks for helping!
| >-----Original Message-----
| >For the date:
| > Do not use one text box. Use three. One for Month,
| one for Day and One
| >for Year. Then validate them to be required a numbers.
| Then, when you write
| >the date to the database put those three numbers together
| as on record.
| >
| >For the text box validation:
| > Select Validation under properties. Under Data Length
| select Required.
| >
| >Mikeal
| >
| >
| message
| >| >> How can I require that a text field on a form in
| Frontpage
| >> utilize a date format? When I select Form Field
| >> Properties for a text box, under Data type, I don't see
| a
| >> Date option...what should I use to make sure data is
| >> entered in date format?
| >>
| >> Also, is there a way in Frontpage to require a field be
| >> entered? I see the Validate button under form field
| >> properties but I don't see where I can select that a
| field
| >> is required when it is a text field.
| >>
| >> My data is being stored in Access.
| >>
| >> Thanks!
| >
| >
| >.
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top