Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    240

    Unanswered: audit trail problem

    Hi

    I've created an audit trail on a form which has a tab control linked to subforms.

    Now when I add a new record in the subforms, it should display in an audit control on the from the following:

    Date updated: 04/11/2005;

    New Record Added;

    But instead it comes out as:

    Date Updated: 04/11/2005;New Record Added;

    Is there a symbol or something that will make the text go onto the next line down, so I can get rid of this problem?

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    "Your first line" & vbcrlf & "your second line"

    vbNewline works as well.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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