Suppress fields on report in certain conditions 1

[AyJayEL]

I am using Access 2000. I would like to suppress or make a field invisible on a report when certain conditions occur. ie when B is ticked don't show Return Date 1. Can anyone tell me how to do this please? Learn something new every day *:->*

 

[Steve101]

Use the Format event of the Detail section of the report. Add the following sort of code to the event:

Dim R as Report: Set R = Me
If R!B then
R!ReturnDate1.Visible = False
Else
R!ReturnDate1.Visible = True
End If

Hope this helps, Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[AyJayEL]

I love this community! Excellent worked like a dream!

Many thanks Andrea. Learn something new every day *:->*