Insert NOW() without overwriting text in memo field

  • Thread starter Thread starter Joshua
  • Start date Start date
J

Joshua

Hello,

I am trying to insert NOW() into a memo field on a form and not overwrite
existing text. We need to be able to type notes and then event assign this
function some how (maybe on enter?) so that NOW() can be entered after the
text.

So basically, in this format:

"Called customer and left message regarding concern. 03/06/2008 11:58:00"

Thanks for any help. It's greatly appreciated.
 
Create an After Update event or macro to Set Value the field with ---
" " & Now() & " - " & [YourMemoField]
This place the date and time in front of the comment.
All later comment will be --
LastDateTime - LastComment PriorDateTime - PriorComment etc.
 
Joshua,

If you are using Access 2007, you can set the Append Only property of
the Memo field to Yes, whereupon Access will automatically do this for
you. :-)
 
Tried the code below in a macro but nothing seems to happen. added a
RepaintObject to the start of the macro to fix other errors. do i also need
to repaint after the setvalue ? so changes will show up ?

KARL DEWEY said:
Create an After Update event or macro to Set Value the field with ---
" " & Now() & " - " & [YourMemoField]
This place the date and time in front of the comment.
All later comment will be --
LastDateTime - LastComment PriorDateTime - PriorComment etc.

--
KARL DEWEY
Build a little - Test a little


Joshua said:
Hello,

I am trying to insert NOW() into a memo field on a form and not overwrite
existing text. We need to be able to type notes and then event assign this
function some how (maybe on enter?) so that NOW() can be entered after the
text.

So basically, in this format:

"Called customer and left message regarding concern. 03/06/2008 11:58:00"

Thanks for any help. It's greatly appreciated.
Click to expand...
Click to expand...
 
Thanks so much for this. I was able to get this working as I needed based off
of your comments.

I ended up just creating a button the user can click to add the notes at the
end of the field using "[YourMemoField] & " " & Now()"

I hope that helps anyone else having a similar issue.

KARL DEWEY said:
Create an After Update event or macro to Set Value the field with ---
" " & Now() & " - " & [YourMemoField]
This place the date and time in front of the comment.
All later comment will be --
LastDateTime - LastComment PriorDateTime - PriorComment etc.

--
KARL DEWEY
Build a little - Test a little


Joshua said:
Hello,

I am trying to insert NOW() into a memo field on a form and not overwrite
existing text. We need to be able to type notes and then event assign this
function some how (maybe on enter?) so that NOW() can be entered after the
text.

So basically, in this format:

"Called customer and left message regarding concern. 03/06/2008 11:58:00"

Thanks for any help. It's greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top