IIF Statement

[Aurora]

I am using Access 2000

In a form I have a signature field [IA-Sign](text field)
and a date field [IA-Date](date field). I want todays
date to come up automatically in the IA-Date field if and
when someone enters their name in the signature [IA-Sign]
field.

In the date properties of IA-Date, under Validation Rule I
put
=IIf([IA-Sign] Is Not Null,[Date()]," "). But this
does not work. Does anyone have any ideas as to how to
make todays date come up only when someone has completed
the signature field (IA-Sign)????

Aurora

 

[Doug Robbins - Word MVP]

Hi Aurora,

You should ask this in the microsoft.public.access.forms newsgroup.

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP