Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

How to enter Today's Date in Access by a key combination

by Map941 Feb 25, 2006 3:22AM PST

I have used the {Ctrl}+{Semicolon} combination that I found in the Help, but it just moves the cursor inside the field from the mm/ to the dd/ and the values remain blank. What am I missing?

I would appreciate any help.

Map941

Discussion is locked

3 Posts

- Collapse + Expand Details

- Collapse -

Continuation of previous submission

by Map941 Feb 25, 2006 3:42AM PST

I am not creating new records but just need to edit records that have blank date fields. I would like to enter today's date without actually typing it.

Map941

- Collapse -

Re: entering date in MS Access

by Kees Bakker Feb 25, 2006 6:43AM PST

With me, in Access 97, it works perfect, both for new and for existing records under one condition: there's no input mask defined for the field. Obviously, since you have mm/ and dd/ in the field, there's in input mask, and that seems to confuse MS Access.

So I don't think you're missing something, you've got too much.

Hope this helps.

Kees

- Collapse -

Thank You!

by Map941 Feb 25, 2006 8:48AM PST

I appreciate your suggestion. It does work. But, it would be much better if it would work with a mask too. It's all about data entry flexibility and accuracy.

Thank you again.

Map941

Back to Office & Productivity Software forum