PC Review


Reply
Thread Tools Rate Thread

Date format and requiring a field to be entered

 
 
Lori
Guest
Posts: n/a
 
      29th Jan 2004
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!
 
Reply With Quote
 
 
 
 
Mike
Guest
Posts: n/a
 
      29th Jan 2004
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


"Lori" <(E-Mail Removed)> wrote in message
news:67b501c3e6a5$c27cffb0$(E-Mail Removed)...
> 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!



 
Reply With Quote
 
Lori
Guest
Posts: n/a
 
      29th Jan 2004
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
>
>
>"Lori" <(E-Mail Removed)> wrote in

message
>news:67b501c3e6a5$c27cffb0$(E-Mail Removed)...
>> 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!

>
>
>.
>

 
Reply With Quote
 
Crash Gordon
Guest
Posts: n/a
 
      29th Jan 2004
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.


"Lori" <(E-Mail Removed)> wrote in message news:65c101c3e6a8$8b5fee40$(E-Mail Removed)...
| 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
| >
| >
| >"Lori" <(E-Mail Removed)> wrote in
| message
| >news:67b501c3e6a5$c27cffb0$(E-Mail Removed)...
| >> 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!
| >
| >
| >.
| >
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Once date is entered into a field lock the field for read only Lori LeRoy Microsoft Access Form Coding 2 30th Oct 2009 11:19 PM
Select Earliest Date Entered if Date Field Null Laura C. Microsoft Access Queries 1 13th Feb 2009 02:40 PM
Select Earliest Date Entered if Date Field is Null Laura C. Microsoft Access Queries 0 13th Feb 2009 12:28 AM
comparing the date entered to a form and the date field in a table Yue Zhao Microsoft Access VBA Modules 2 7th Dec 2006 10:32 PM
Show all records *days after date entered in date field =?Utf-8?B?UkRSZXNlYXJjaA==?= Microsoft Access Queries 1 28th Oct 2006 04:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:20 AM.