Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Is it possible to set conditional formatting per record on a report?


    I'm trying to format a report to have records that contain certain data in bold.

    Unfortunatly I cant seem to get reports to look at 1 field and format the other fields acording to that 1 field.

    I'm testing this bit of code here, but Ive come to a dead end. The report always thinks that this text box is not null...

    Option Compare Database
    Private Sub Report_Open(Cancel As Integer)
    Dim UDF As Control
    'UDF = Me.Controls!UDF1
        If IsNull(Me.UDF1) Then
            Me.Controls!DwgTag.FontWeight = 400
            Me.Controls!DwgTag.FontWeight = 700
        End If
    End Sub
    Thanks in advance

  2. #2
    Join Date
    Sep 2003
    Caldes de Malavella, Spain
    You need to run your code from the Detail section's "On Format " event.
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy

Posting Permissions

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