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

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

    Hi,


    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...

    Code:
    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
               
        Else
        
            Me.Controls!DwgTag.FontWeight = 700
                
        End If
    
    
    End Sub
    Thanks in advance

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

Posting Permissions

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