Shortcut date is wrong-twilight zone (1 Viewer)

froggiebeckie · Dec 17, 2018

OK, this isn't world shattering, but it's weird as anything.

I have a database to track keys issued.
Very simple.

One form has a field for Date Issued.

I can key in the date with no problem.
But, if I use the shortcut (Ctrl/Shift/

it puts the date in but has 2020 as the year.

Anybody know why this would happen, or are we just dealing with more Twilight Zone stuff?

Thanks
BeckieO

isladogs · Dec 17, 2018

What shortcut was that really? The emoji clearly wasn't intended.

froggiebeckie · Dec 17, 2018

Shortcut key is the Control key with the colon-semi colon key. I entered it in wrong in the first post.
It's supposed to put today's date in the field.

isladogs · Dec 17, 2018

I'd never heard of that so I looked it up at https://support.office.com/en-us/article/keyboard-shortcuts-for-access-70a673e4-4f7b-4300-b8e5-3320fa6606e2

You hadn't got it quite correct!

Just tested and both work perfectly for me

Gasman · Dec 17, 2018

If you try it in Excel what do you get.?

Also what does ? Date() show in the debug window.?

isladogs · Dec 17, 2018

Both shortcuts work for me in Excel as well (but not Word)

Gasman · Dec 17, 2018

isladogs said:
Both shortcuts work for me in Excel as well (but not Word)

I have rarely used the time method, but have used the date method for as long as it has been available.

The_Doc_Man · Dec 18, 2018

In fact, I have often used both as ^; {space} ^{shift}; to put date and time separated by a single space when making a log entry that needed to be time-stamped.

froggiebeckie · Dec 19, 2018

OK, thanks all.

I'm sorry I didn't type in the shortcut keys correctly, but I've been using both of them for years with no issues.

The problem is, in this one db only, when I try to use the shortcut key to enter today's date, the year it puts in is not right.

example:

12/19/2020 instead of 12/19/2018

Obviously, i have a setting wrong somewhere and was hoping someone could point me in the right direction to save me some time.

I'll keeping searching and will update if/when I find the solution.

Again, Thanks All.

Cronk · Dec 19, 2018

The short cut inserts the current date as per the computer settings. The post by Gasman in #5 was to check if your computer was set to year 2020

froggiebeckie · Dec 19, 2018

I tried the
? Date () suggested by GasMan and got the correct date 12/19/18.

When I use it in Excel, it gives me the right date.

And when I use the shortcut in a different Access db on the same computer, it also acts correctly.

Seems to be something specific to this one db.

Well, you know this is going to drive me buggy, till I find the glitch.

Thanks everyone, you've helped me narrow my focus.

BeckieO

Cronk · Dec 19, 2018

Is the Autokeys macro at play here? It can be used to override the normal short cut key behaviour.

isladogs · Dec 19, 2018

Or possibly an auto correct entry?
Does it still happen if you use the four digit year setting?

Gasman · Dec 19, 2018

Put the DB on another computer and try there.?

Gasman · Dec 20, 2018

Is there any code associated with that control.?

Shortcut date is wrong-twilight zone (1 Viewer)

froggiebeckie

Registered User.

isladogs

MVP / VIP

froggiebeckie

Registered User.

isladogs

MVP / VIP

Attachments

Gasman

Enthusiastic Amateur

isladogs

MVP / VIP

Gasman

Enthusiastic Amateur

The_Doc_Man

Immoderate Moderator

froggiebeckie

Registered User.

Cronk

Registered User.

froggiebeckie

Registered User.

Cronk

Registered User.

isladogs

MVP / VIP

Gasman

Enthusiastic Amateur

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread