How to default to a date in the past

[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

 

[Dirk Goldgar]

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.

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?

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

 

[Jeff Boyce]

Dave

Dirk's provided a way to set the Default value.

Be aware that Default only applies to NEW records. If your table already
has records in it, you'll need to use an Update query to set those dates.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Dave]

Exactly what I needed.

Thanks much for the replies

dave