Table field "memo"

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

Guest

I have a field set as a memo pad and I want access to enter a time and date
each time the field is access and a comment put in

Can anyone help
 
Bill

While it is possible to do, you will make searching the "memos" much slower
and more difficult.

Have you considered using a (one-to-)many table, with one row for each
date/time/comment? You could use =Now() as the default value for a
date/time field, and add a text field for comments (if under 255
characters).

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top