Table field "memo"

[Paignton Bill]

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

 

[Jeff Boyce]

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>