General Date Format: Missing Time

[ozsupra]

I have set a field on my FORM with the General Date format. Every time I use the date picker it inserts the correct date with a time of 00:00? I even changed the format on my table to general date - still no luck

I don't understand why?

 

[Uncle Gizmo]

Add your own command button with code similar to this:-

txtYourTextBox = Now()

 

[ozsupra]

Thanks that does work however I still don't understand why the general date format doesn't.
Even txtYourTextBox.Format = "dd/mm/yyyy, hh:nn" doesn't capture the time

 

[Uncle Gizmo]

>>> I use the date picker it inserts the correct date with a time of 00:00<<<

The Date picker only gets the date.

 

[balahawy]

i want the user to write any date and time in same field in my form but not want to choose function now()
any suggestions