Form looks at dates before 1900 as invalid

J

joe smith

I created a form with a date field that is nothing special. The date is
simply formatted MM\dd\yyyy.

When I try to enter any date before 01/01/1900, it gives me the error that
"a valid date or time is required"

Any ideas???
Mark
 
B

Bob Buckland ?:-\)

Hi Mark/Joe,

See if the information in this article helps:
http://support.microsoft.com/?kbid=209725&FR=1

========
I created a form with a date field that is nothing special. The date is
simply formatted MM\dd\yyyy.

When I try to enter any date before 01/01/1900, it gives me the error that
"a valid date or time is required"

Any ideas???
Mark >>
--
I hope this helps you,

Bob Buckland ?:)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

The Office 2003 System parts explained
http://microsoft.com/uk/office/preview/system.asp
 

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

Top