date shortcut format

M

MonniqueA

Hello - When I use the date entry shortcut (CTRL + :), the
current date will appear but the year shows as 2020. I've
checked the system date and it's correct. Can you help me
straighten this out? Thanx!
 
A

Allen Browne

Very strange.

What is in the Format property of this text box (in form design view),
or field (in table design view)?

How is your Short Date defined in the Windows Control Panel (under Regional
Settings)?

Which version of Access is this?

Is there any macro named "AutoKeys" in your database?
 
M

Monnique

Thank you for your suggestions Allen Browne. The date
settings on my control panel were all wrong and that's
what was causing that strange date thing. It's all fixed
now and it works like a charm! Thanks again!
 

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

Countdown macro - display settings 2
Assigning function to Ctrl+Space and it worls wrongly 2
Autofill Date in Word 15.33 for Mac 0
VBA - exporting serial letters to single documents 0
Copy previous record into form field 0
Interchange line break and paragraph break shortcut keys 9
Excel does not accept text format! 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0

Top