Text Box Default Value Not Showing

Q

QuantumLeap

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
 
B

BruceM

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?
 
Q

QuantumLeap

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.
 
Top