how do i do this, or can it be done?
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
Does anyone have any suggestions?