Prev: datasheet: ?how to order by the 2nd column of a combobox?
Next: Datasheet view change
From: Renee on 5 May 2010 14:43
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
field...is 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
settings?

MS Access 2007, Windows 7.

Thank you for any help with this.
From: Jeanette Cunningham on 5 May 2010 19:01
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
=Now()

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


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Renee" <Renee(a)discussions.microsoft.com> wrote in message
news:7CE0A95F-9ED9-4B92-ABFE-AB0521BE9A5E(a)microsoft.com...
> 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
> field...is 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
> settings?
>
> MS Access 2007, Windows 7.
>
> Thank you for any help with this.


 | 
Pages: 1
Prev: datasheet: ?how to order by the 2nd column of a combobox?
Next: Datasheet view change