Hello,

I have an access report. In my detail line I have a field as an indicator for each record. There are 6 of these indicators; 1 through 6. So if the line printed is 1, I want a rectangle to be visible in a specific area of that layout. If the record indicator is 2, I want a rectangle to be visible in a different area and all other rectangles to become invisible.

I've done this to start with just to get the first box to appear, but it doesn't work:
In the 'ON FORMAT' property of the detail layout, I used 'code builder'. Here is the code:

If Indicator = 1 Then
    Access.acRectangle.boxTest.visible
Else
    Access.acRectangle.boxTest.invisible
End If


Does anyone have any suggestions?
Thanks!

I would think that if each rectangle has a unique name i.e. rectNumberOne, then you could use code like

If Indicator = 1 Then
    rectNumber1.visible = True
Else
    rectNumber1.visible = False
End If

Mike

Mike
EchoVue.com

Timbal25,
Check out using a case statement.

also to set the visible property you need to use true or false.
If Indicator = 1 Then
    Access.acRectangle.boxTest.visible = true
Else
    Access.acRectangle.boxTest.visible = false
End If


dartcoach

AWESOME!!!! That works great.... Thanks both Mike and Dartcoach.