Simplified Date & Time entry

[AdamAA]

I have a form with a Time/Date field. At the moment you have to type in the full date then press space, then two numbers, colon, two numbers.

If you just type in a time, it defaults the date to 1900. If you only type in the date, it only shows the date..

Would there be a way to make it so that we can type in 4 numbers (i.e. 1800) and it auto-fills the field with today's date and displays the four numbers as a time?

 

[James Dudden]

You could have 2 seperate fields - one that is formatted to show just time and where you would enter the time and the other to be formatted with date/time and is populated after the first one.

 

[Brianwarnock]

The second field could be a fixed number no decimal places field with a lost focus code of me.datefield = Date & " " & Left(me.text1,2) & ":" &Right( me.text1,2)

Text1 is the second control

Brian