How do I display a memo field to a Form in Access

0
votes

I have looked at the previous questions asked relating to this but haven't been able to find a solution. I have a table with a memo field called "Comments", and I am trying to display all the history of the field in the form. In the text box properties in the control source I have this:

ColumnHistory([Positions], [Comments], [JobID=]&[JobID]) (Positions is the table name, Comments is the memo field, and JobID is the primary key indentifier). I get a #Name error in the field and I dont understand why. I am very inexperienced with databases but am trying to learn and do this project. Any Help is appreciated Thank you

1
ms-accessms-access-2007

1 Answers

1
votes

First of all, make sure the Comments field's AppendOnly property is set to True or this will not work.

Next, the code in the text box control should read:

= Application.ColumnHistory("Positions", "Comments", "JobID=" & Me.JobID & "")

If any of your variables, objects or controls is different than stated, you might need to tweak that a bit.

I see you're new here, so please make sure that you confirm whether or not this worked for you so future visitors with similar questions will know if the answer is viable.