Date Picker Default?



In a form where a datasheet is a subform, and where the last line is the data
entry line, and where the first field of the data entry line is a date picker there a way for the date picker field to defualt with the current
date w/out having to use the date picker? In other words, can the field
always show the current date, and if it needs to be different, the user can
click the date picker and choose a different date? If so, how do I fix the

MS Access 2007, Windows 7.

Thank you for any help with this.

Jeanette Cunningham

Here is how to set a default date for a textbox on a form.
In design view, select the textbox,
on the property dialog for the textbox, on the data tab,
find the property called Default Value and enter
= Date()

If you want both date and time, enter

Access sometimes removes the brackets after Date() or Now(), that doesn't

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 date picker property 2
Date Picker question 1
Date Picker with Inputmask 3
date picker problem. 4
>> Access 2007 textbox date setting 1
date time picker 4
Date input 2
Error with Date Picker 3