Art:"Add this"&[Date]&" to my memo field."

[Zachry1]

I have a field Memo, named Art and I would like to insert a date so that when
my users see the memo field in a form they will also see the embedded date
field which comes from the same table and record.
Is this possible???

 

[fredg]

I have a field Memo, named Art and I would like to insert a date so that when
my users see the memo field in a form they will also see the embedded date
field which comes from the same table and record.
Is this possible???

Your question is not wholly clear.
Do you wish to add a date that has previously been entered in a Date
field into the Memo field after the Memo data has been added?

Code the [Art] AfterUpdate event:
Me![Art] = Me![Art] & " " & [DateField]

Or did you want to actually add the current date into the Memo field:
Me![Art] = Me![Art] & " " & Date

 

[Zachry1]

Fredg,
Thanks for your reply.
I want to insert data from several fields unto a long memo field so that it
reads correctly and makes sense. My users will be allowed to edit the wording
in the memo field, but they need to see what is being inserted from the other
fields.
I can write the logic in a query, but my users cannot edit the wording here.
The [date] was an example and i don't want to add the date() function, just
the data stored in the date field.

I have a field Memo, named Art and I would like to insert a date so that when
my users see the memo field in a form they will also see the embedded date
field which comes from the same table and record.
Is this possible???

Your question is not wholly clear.
Do you wish to add a date that has previously been entered in a Date
field into the Memo field after the Memo data has been added?

Code the [Art] AfterUpdate event:
Me![Art] = Me![Art] & " " & [DateField]

Or did you want to actually add the current date into the Memo field:
Me![Art] = Me![Art] & " " & Date