changing background color automaticaly

[JackSparks]

Hi,

I'm working on a simple d-base to track some work in my office. I'd like to build a button that one could press when the task is done and it changes the background color on that particular record as an easy reference to anyone that this task is complete. Does anyone have any idea how to change make this happen?

Thanks,

Jack

[Kurt Knippel]

Your "background color" becomes a calculated field of type Container. For instance:

cBackground = If ( status = "Completed", gCompletedColor, "" ).

All that you need to do is to put a color swatch into the global container gCompletedColor and format the field appropriately.