Access 2007 Issues Template

Topic

New Reply

I downloaded the Issues template in Access 2007. There is a form and it has a field called History on the form. For the Control source it has =ColumnHistory([RecordSource],”Comments”,”[ID]=” & Nz([ID],0))

My problem is you can’t edit the field or delete what is in the field. It keeps repeating what is in the Comments field whenever the record is open. See Attachment

Is there some kind of code that will just add something to history when there is a change to the comments field?

Reply | Quote

Replies

Did you forget the attachment?

Reply | Quote

In 2007, Memo fields have a new Property “Append Only”. When this is set to Yes, it leads to the behaviour you observe.
The idea is that it records a history of changes that cannot be edited by users.

If you want to be able to edit the field, change Append Only to No.

Reply | Quote

Is there some kind of code that will just add something to history when there is a change to the comments field?

For the ColumnHistory method see ColumnHistory Method [Access 2007 Developer Reference]

I didn’t find anything in the help-file

Reply | Quote