Use form to append a text field in a record without overwriting existing text

[murleyj]

How can I use a form to append a text field in a table without overwriting the existing text.

Example:

My current text field [ApprovalComments] in a table named [DocumentControl] contains the following text:



Rev A - approved by JBM 6/03/2014



I would like to use a form and have it append the existing text to read:

Rev A - approved by JBM 6/03/2014
______________________________

Rev B - approved by JBM 6/04/2015


So I have essentially preserved the existing text and added a seperating line and a new line of text.

Can this be done?

Thank you!

[June7]

Really should have a related table for multiple comments. Each comment would be a new record.

Otherwise, user must know to go to end of the text in the field and enter new info

OR

use an UNBOUND textbox and VBA code to concatenate the text strings and save the new value.

This is a poor db design.

[murleyj]

I don't have that option. I am working on a database that is part of some software. At its core is an Access database. I am interacting with this part of it using an Access form which will write to several tables at once.

[murleyj]

June7 what VBA code would I use? I do not know how to write that.

[June7]

Something like:

If Not IsNull(Me.textboxname) Then Me!fieldname = Me!fieldname & vbCrLf & Me.textboxname

The real trick is figuring out what event to put the code into. Maybe the form BeforeUpdate.

[murleyj]

Ok, thank you. I will try it and see what I come up with.

[June7]

Wait, I goofed on code.

Me!fieldname = Me!fieldname & IIf(Not IsNull(Me!fieldname), vbCrLf, "") & Me.textboxname

[murleyj]

ok, thanks. I will try it.