How to change background color based on field?

[chrisabruce]

Is there a way to change the background color of a layout based on a field? I want to signify a specific type of user by changing the background color of the form when based on a field.

[LiveOak]

Use a calculated container field as the background for your layout. Create fields:

gRed (global, container)

Background (calculation, container) = Case (YourTest, gRed, "")

Replace "YourTest" with a test for the condition you want to cause the background to show a color. You can also use two colors, store each color you wish to use in a global container field by drawing a rectangle in layout mode and making the lines and fill the color you wish. Copy the rectangle in layout mode, switch to browse mode, click in the color storage container and paste. Be sure to set the background container "graphic" formatting to "reduce or enlarge" and uncheck "maintain proportions". The background color globals must be setup with the file opened in client FM with the file not hosted on FM Server.

-bd

[LaRetta]

That is sweet! I like the thought of changing my background to signify to the user that they're on a new record better than flashing the words at them! I'm going to try it now!