Date using keyboard shortcut

C

Carol

I have a user who uses keyboard shortcuts to enter the date. on one
form in the database it enters correctly as todays date - he then goes
into a another form in the database and the year comes up as
11/09/2020 - if you manually type the dat eg 110903 it correctly
reverts to 11/09/2003.
He is using access 2002
 
A

Allen Browne

Ctrl+semicolon should enter today's date.

The text box bound to a field of type Date/Time does not accept 110903
without separators. Perhaps you are using some kind of input mask or other
device that is missing up the entry?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Function in access 2
keyboard shortcut for dates and Time 4
Date format automatically changed 1
Using SkipIf with date problem 1
Excel date intervals look up 1
Insert character in a cell using a keyboard shortcut 10
Keyboard Shortcut for Date 1
Payment Plan Database 4

Top