November 5, 200124 yr 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
November 5, 200124 yr 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.
Create an account or sign in to comment