Insert Date in a memo field

[Guest]

We have a memo field that we use for on going notes.
Each day they may type more notes.
Is there a shortcut key, a button, or a way to automatically enter the date
and time before the notes?

 

[John W. Vinson/MVP]

We have a memo field that we use for on going notes.
Each day they may type more notes.
Is there a shortcut key, a button, or a way to automatically enter the
date
and time before the notes?

Storing multiple pieces of data - multiple dates and times, multiple notes -
in one single memo field is a Bad Idea, I fear. I'd strongly suggest instead
creating a new Notes table, related one-to-many to this table. This could
have a date/time field defaulting to Now() to automatically timestamp the
note, and would allow easy searching for notes with specific content, notes
on a specific date, etc.

Use a Subform on your main form to edit these notes.

John W. Vinson/MVP

 

[Danny J. Lesandrini]

Have them hit Ctl+{Colon} for date, Ctl+{Semicolon} for time.

 

[Guest]

That is just was I was looking for!
Thanks

Have them hit Ctl+{Colon} for date, Ctl+{Semicolon} for time.

--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast