Need Some Help with Continuous Forms

[phobia42]

Hello, I am working on a project in Access 2003 where we are using a recordset to display the details of a table on a custom form, and we need to display a color depending on the value of a specific field in the dataset. We only need to display a colored square, so any reliable method to do this would work fine (ie. OLE object, colored textbox, image, etc.). we need to display 4 different colors, so using the conditional formatting won't work. Which number translates to which color will be fixed so it can be hardcoded. Any suggestions would be greatly appreciated.

 

[pdx_man]

I believe you have 4 different options available to you under conditional formatting ...
Use the 3 conditions for 3 of the values and the Default Formatting for the 4th value ...

 

[Mike375]

I believe you have 4 different options available to you under conditional formatting ...
Use the 3 conditions for 3 of the values and the Default Formatting for the 4th value ...

I did not realise that until now Just tried it. In fact it wasn't until about a year afer I got Access 2003 that I knew it was there at all.

Only about a month ago I wanted four conditions for font colour and use 4 calculated query fields with 3 always being null and with the 4 fields over layed with the top 3 having transparent backgrounds