Datepicker default as today

[McFestoe]

Using the date picker on a form, i have tried various ways of geeting it display the current date, but itstead in reverts back to the date in the properties box.

Is there a way to get it to display the current date.

Tried to get the form on open to set the date via

dt2picker.value=date()

But just cant seam to get the date as todays when the form opens.

 

[Remou]

Try setting the date in the load or the current event. There are a lot of problems with the date picker, particularly if you wish to distribute the database, so this is oftenn recommended:

http://www.mvps.org/access/forms/frm0057.htm

 

[ClydeData]

You could also try this

http://www.peterssoftware.com/prx.htm

or

http://allenbrowne.com/ser-51.html

hope this helps

jimmy

 

[ZmrAbdulla]

try

dt2picker.value=vba.date()

________________________________________________________
Zameer Abdulla
Help to find Missing people