can i assign a background color on a field depending on the result of the field. eg field="Yes" background="Green", field="No" background="Red"

Yes. You can do it with either a repeating global container field or serveral global container fields to store the background colours.

For your case, define 2 global container fields:

g_Red_Background

g_Green_Background

You need to fill these containers with the appropriate colour by going to layout mode, drawing a little red line, copying it, go to browse mode and paste into the g_Red_Background... similar for green.

Now define 1 calculation field (container) called Text_Background which =

if(MyText="Yes",g_Green_Background,if(MyText="No",g_Red_Background,""))

Format this field (graphic) to expand to fill and uncheck the maintain proportions. Also format it as transparent and not to allow entry. Place this field behind your MyText field on the layout, ensuring that MyText is transparent.

Now "yes" will have a green background, "No" will have a red background and "" will have your layout background colour.

Hi Aussie,

Yes you can implement background colors that change based on a value entered into a field. Instead of trying to explain what to do, I created a sample file. I will e-mail it to you.

Take a look at the:

- Define Fields...

- Define Value Lists...

- Layout

- ETC., ETC.

There also a 'surprise' that is helpful to users!

Hope this helps...

Bob Kundinger