Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Did you forget the attachment?
    Regards
    John



  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    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.
    Regards
    John



  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by LindaR View Post
    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
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •