Display or not picture in report

[josip]

Hello ,
I try to setup a code in which I want to test on the condition to display or not display a picture in a report.
First a question :
- do I have to open the report before or after the condition tests ?

The pictures - !YouaredoingGreat are predefined pictures in my report with the property 'visible' off

My code :

Dim weekrapport2 As Report
    Set weekrapport2 = Report_WEEKRAPPORT
 
With weekrapport2
 
If weektotaalgained > 69 And weektotaalgained < 80 Then
!YouaredoingGreat.Visible = False
!YouaredoingGood.Visible = True
!YouaredoingGood2.Visible = True
!YouaredoingAverage.Visible = False
!YouaredoingBellowAverage.Visible = False
DoCmd.OpenReport stDocName, acViewPreview
End If
 

The result of this :
no error message, condition is fulfilled, picture is not visible ! Why ????

Thanks

[jforbes]

You'll want to move the code to set the images visible or not into the Report. Probably in the GroupHeader_Format or Detail_Format.

Here is an example of using an Image in a Footer. Hopefully it helps:

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
    Dim sSigFile As String
    sSigFile = Nz(Me!SignatureFile, "")
 
    Me.imgSig.Visible = False
    If Me!UseSignatureImage <> 0 Then
        If Len(sSigFile) > 0 Then
            sSigFile = gResourceDirectory & "\Signatures\" & sSigFile
            If fileExists(sSigFile) Then
                Me.imgSig.Visible = True
                Me.imgSig.Picture = sSigFile
            Else
                Call msgBoxError("Could not find the Signature file at: " & sSigFile)
            End If
        End If
    End If
End Sub