If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
date shortcut format
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! |
#2
|
|||
|
|||
date shortcut format
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? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "MonniqueA" wrote in message ... 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! |
#3
|
|||
|
|||
date shortcut format
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! -----Original Message----- 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? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "MonniqueA" wrote in message ... 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! . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing text to date format | J M Woodgate | General Discussion | 2 | August 13th, 2004 06:23 PM |
date format conflict | steve mckenna | Running & Setting Up Queries | 5 | July 13th, 2004 12:42 PM |
Date format YYYYMMDD | John C. Das | General Discussion | 1 | June 15th, 2004 12:17 AM |
Word 2002 form letter date format | Jonny | Mailmerge | 1 | April 25th, 2004 02:28 PM |
Pivot Table - Format of Date Field | Peo Sjoblom | Worksheet Functions | 0 | February 3rd, 2004 07:20 PM |