Hi all,
I have form that acts as a display board. Every few minutes it refreshes. The refresh can take up to 10 minutes as there is plenty of data to pull down.
My issue is that one of the fields is a conditionally formatted field. If the value is 1, it shows a green box, 2 yellow, and 3 red.
When the refresh takes place and the queries are running. The conditionally formatted field blanks out and waits for all the refresh queries to complete.
Does anyone have any ideas to display 3 colored boxes based on a value that won't do this during runtime?