Problem with Custom Form Validation

[David]

Hi All,
I have added a new field label and text box to a custom Contact form
that I created. The text box is suppose to hold a date time stamp of the
last time the person was contacted. I created a new field and called in
"Last Contact".

For the text box, I have the validation properties set to the following
formula:

([Last Contact] = "" OR [Last Contact] = "None") OR (IsDate([Last Contact])
and [Last Contact] < Now())

Here are the two problems
1) A last contact of blank and "None" works, but any date time stamp doesnt

2) The control doesnt save the value if it is changed

I am using Outlook 2000 on a Window XP box.

Any help would be appreciated.

David

 

[David]

It only took me a hour but the correct validation string is:

IIf(IsDate([Last Contact]), [Last Contact], IIf([Last Contact] <> "" AND
[Last Contact] <> #1/1/4501#, [Last Contact], #1/1/4501#))