Insert Date in a memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Becky said:
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?
Click to expand...

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
 
Back
Top