How to default to a date in the past

D

Dave

Access 2007 and Access 2003

I have an unbound text box that I want to "default" to a date 6 number of
days in the past from today?

I do I do that.

Also is there anyway in Access 2007 to get the built in calendar popup to be
assigned to an unbound text box?

thanks

dave
 
D

Dirk Goldgar

Dave said:
Access 2007 and Access 2003

I have an unbound text box that I want to "default" to a date 6 number of
days in the past from today?

I do I do that.
Click to expand...

You could set the control's DefaultValue property to

=DateAdd("d",-6,Date())
Also is there anyway in Access 2007 to get the built in calendar popup to
be assigned to an unbound text box?
Click to expand...

If you set the control's Format property to one of the date formats (e.g.,
"Short Date" or "General Date"), then it should be recognized as a date
field and the date picker should be displayed so long as the Show Date
Picker property is set to "For dates".
 
Top