Date shortcut

C

C Tate

When I hit CTRL + ; to enter the current date in MS Access I get a strange
result. Yesterday it came up with 15/06/20. It then said the date was in the
future. What I was trying to enter was, of course, 15/06/04. Why is this
problem occuring?
 
W

Wayne Morgan

Do you have an Input Mask on the field that may be limiting the year to 2
digits? I recommend setting everything to display 4 digit years.
 
C

C Tate

I suppose there must be a mask. Unfortunately I cannot change this as it is
not my own database.
 

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 Problem 3
Reverse Index Match 2
Arranging dates in a single column 5
Find then highlight in yellow 6
Stumped By Dates 4
Office 365 Outlook adding unwanted HTML to Email Body 0
Default date format (with shortcut keys) 2
Add Hours by Looping through Data Q 27

Top