How do I default a text box in an Access page to the current date.

  • Thread starter Thread starter Guest
  • Start date Start date
On the properties sheet, set the default value to "=Date()" without the
quotes. Each time a new record is created with the form, your text box will
be populated with the current date.
 
Set the defaul value to Now()

Mark said:
On the properties sheet, set the default value to "=Date()" without the
quotes. Each time a new record is created with the form, your text box will
be populated with the current date.
Click to expand...
 
Be aware, though, that Now includes both date and time.

While that's often what you want, it does mean that you will be unable to
simply query by date: you can't, for instance, do a SELECT * FROM MyTable
WHERE MyDateField = #08/24/2005# to get all of the records associated with
yesterday. (Of course, there's an easy workaround: SELECT * FROM MyTable
WHERE MyDateField Between #08/24/2005# And #08/25/2005#)
 
You must log in or register to reply here.

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

Hello happy new year to all, Text box input for year of purchase 0
Excel Default Text Size in Comments box 1
Access 2 Digit year in Access Text Box 3
Current Date and Time functions in Access 2
=date() default setting returning #name? text in object box 2
Text to date format? 0
Query Results in a Text Box 3
Auto Date for check boxes 13

Back
Top