Text Box Default Value Not Showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2002.

I have a text box, edate, on my form with the following default value:
=Date()-IIf(DatePart("w",Date())=2,3)

When I first changed the default value to that from the previous value of
Date(), the default value was visible on the form before anything was updated.

Something on the form has been changed, so now edate does not automatically
show the default value.

What can I do to fix this?

Thanks
 
Just to make sure it's clear, default value applies only to new records.

In your IIf statement, if DatePart = 2 you subtract 3 from today's date, but
what do you do if DatePart is something other than 2?
 
Ah. The default value should be:=Date()-IIf(DatePart("w",Date())=2,3,1).

I did not realized that the end of that statement had changed.

Thank you for your help.
 
Back
Top