This is a simple one but I am unable to find it from research. I want to enter the date and time in a date field. When I am in the field and I hold the Ctrl key and press enter the date is entered without me having to type in the date. I cannot get the time and date together eg 10/12/2007 3:30pm.

Also if I have a date field how can I enter the time only. Is there a shortcut that allows this without me having to type say 3:45 PM?

Thanks for the help

I would add buttons to the form to do this, although you can create shortcut keys for it. The button code would be:

Me.DateAndTimeField = Now()
'This returns the date and time

Me.TimeOnlyField = TimeValue(Now())
'This returns just the Time portion of the date and time

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com