dtpicker to display current date when form opens

's Computer Specifications

I have a DT picker in a userform. I would like it to display the current date
on opening.

Your assistance with this would be much appreciated.
--
Thanks

Ron

's Computer Specifications

I don't know what date picker you're using, but maybe...

Option Explicit
Private Sub UserForm_Initialize()
Me.Calendar1.Value = Date
End Sub

ron mann wrote:
>
> I have a DT picker in a userform. I would like it to display the current date
> on opening.
>
> Your assistance with this would be much appreciated.
> --
> Thanks
>
> Ron

--

Dave Peterson

's Computer Specifications

Hi Dave,

I am using DT picker and the suggested initialisation has worked a treat.

Many thanks to you.

Cheers

Ron

"Dave Peterson" wrote:

> I don't know what date picker you're using, but maybe...
>
> Option Explicit
> Private Sub UserForm_Initialize()
> Me.Calendar1.Value = Date
> End Sub
>
>
>
> ron mann wrote:
> >
> > I have a DT picker in a userform. I would like it to display the current date
> > on opening.
> >
> > Your assistance with this would be much appreciated.
> > --
> > Thanks
> >
> > Ron
>
> --
>
> Dave Peterson
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bound Date/Time field to automatically display the current date	Billiam	Microsoft Access Database Table Design	2	20th Sep 2009 11:13 PM
Re: Combos show current when form opens	Piet Linden	Microsoft Access VBA Modules	0	26th May 2009 04:07 AM
display current date and time continuously in form entry	=?Utf-8?B?QWxleCBOeWFsZXk=?=	Microsoft Access Forms	1	22nd Aug 2007 02:43 PM
Combo box opens form to current selection, Else if blank opens to New	Terry B via AccessMonster.com	Microsoft Access Form Coding	3	23rd Sep 2005 04:22 PM
Calendar in a form to display current day and date	jh	Microsoft Access Form Coding	1	22nd Jul 2003 01:28 AM