Todays date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moody - 29 Jan 2006 16:57 GMT

Hello,

i have done this before but i cant recall, how do i enter todays date in a
date field by clicking a command button or even have the date already on the
field when the form opens, would this require me to go back to the table or
can i do this from the form.

can anyone help, sorry to sound silly but i cant seem to do this.

Thank you

Reply to this Message

Allen Browne - 29 Jan 2006 17:07 GMT

Open the form in design view.
Right-click the date field, and choose Properties.
Set the Default Value property to:
=Date()

You can enter today's date with the keyboard by pressing Ctrl+;

In code, you could assign today's date to a control named InvoiceDate with:
Me.InvoiceDate = Date()

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> i have done this before but i cant recall, how do i enter todays date in a
> date field by clicking a command button or even have the date already on
> the
> field when the form opens, would this require me to go back to the table
> or
> can i do this from the form.

Reply to this Message

Moody - 05 Feb 2006 14:12 GMT

Thanks, sorry for the late reply

> Open the form in design view.
> Right-click the date field, and choose Properties.
[quoted text clipped - 12 lines]
> > or
> > can i do this from the form.

Reply to this Message