Conditional object visibility

[way2bord]

I have a table w/field: Number {1,2,3,4,5,6,7,8,9,10}
I have a report based on the table containing:

1 field: Number, box A and box B.

I would like for the report to show Box B if Number > 5, else show Box A.

How do I do this?:banghead:

 

[pbaldy]

This type of thing in the format event of the section containing them (probably detail):

http://www.baldyweb.com/ConditionalVisibility.htm

Or you can use Conditional Formatting, setting the font and backcolor the same.

 

[way2bord]

Just figured it out at the same time you posted.

I kept sticking conditions into the on open of the report and it wouldn't recognize anything...

 

[way2bord]

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Me.numbers > 5 Then
        Me.Box2.Visible = True
        Me.Box1.Visible = False
    Else
        Me.Box1.Visible = True
        Me.Box2.Visible = False
    End If
End Sub

Why do boxes show up in print preview, but not when Report View.

 

[pbaldy]

The detail format event does not fire in Report view. I lost a lot of hair on that one. :banghead: