Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    104

    Unanswered: Format event on Access Report

    Hi, I have a line in report's detail unit in order to seperate one record from another. But I want, this line, to change its BorderWidth property each time a specific record appear. I have created code in Format event that do this but this change appear to all records in detail unit.Why?

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    The format even occurs each time a record is formatted for your report.

    You said
    I want, this line, to change its BorderWidth property each time a specific record appear
    You need to put some logic in the format event to find your "specific record"

    Code:
    If 'specific record' Then
       BorderWidth = Wide
    Else
       BorderWidth = Thin
    EndIf

  3. #3
    Join Date
    Feb 2004
    Posts
    104
    Ok thanks "ottomatic". I hadn't put the "else" statement.

Posting Permissions

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