I have a form I use to enter info to a form. I return to this form every 5-6 months I note the condition of the piano each time I work on it I would like to date/time stamp my notes entry. Is there a way to insert date time into a field on a form, that reports to a table, by pushing a function key. I would like to push say "f4" and have the date time populated then type my notes in the memo field.

There already exists an Access Shortcut to do this:

<Ctrl> + <;>

Would that suffice or does it have to be one-key deal?

To re-assign the F4 Key, code like this

You must set the Form's KeyPreview Property to YES!



You'll need to replace MemoField with the actual name of your Textbox, of course.

Also, be careful in choosing an F Key to re-assign; its native Access function will be cancelled.


Linq ;0)>

This post has been edited by missinglinq: May 5 2012, 08:40 AM

cntrl : will work just fine Thanks

Glad we could help!

Linq ;0)>