Graphic display in repeating field

[KnightShift]

Senerio: Purchase order system using one layout for all departments. This layout has a repeating price field of 75 cells (uses the sliding/printing function). Some departments should not see the pricing entires. Because the font color can not be dynamicly changed (from black to white) I will have to 'mask out' the price fonts from behind using a graphic (similar to a maxicode bar code pattern)in a separate repeating field using the cells as containers.

Problem: Setting the background field as a calculation, how do I bring in a pattern for each cell used in the pricing field? (Pattern is in a gobal container)without have to write 75 statements.

[BobWeaver]

You don't need to go to this trouble just to hide information. Just replace the price field with a calculated field cDisplayPrice with the formula:

Case(Extend(AllowToSee),Price,"")

The field "AllowToSee" should be a regular field or a global field with a value of 1 when the price should be displayed, and 0 otherwise.

And now for the usual admonition. You shouldn't be using repeating fields. You should have a related line items file.