Display Color based on Field Contents

[davidol]

I would like be able to have a box or retrieve an image for instance, that is Green when the Status Field = "1" and Red when the Status Field is "0" on a form.

Any suggestions?

Thanks

 

[dannyocean]

Here is an example of some code from the detail section of a report on format property

If (two > Daily_Goal_MER) Then
[two].ForeColor = 255
Else
[two].ForeColor = 16711680
End If


Mine is a calculation based result. [Two] and [Daily_Goal_Mer] are both field names from my table.

Your solution should be quite similar.

 

[dannyocean]

Here is an example of some code from the detail section of a report on format property

If (two > Daily_Goal_MER) Then
[two].ForeColor = 255
Else
[two].ForeColor = 16711680
End If


Mine is a calculation based result. [Two] and [Daily_Goal_Mer] are both field names from my table.

Your solution should be quite similar. 255 is red and 16711680 is blue.

 

[davidol]

Cool for reports! Any ideas on something similar on a form, without the user needing to "click" anything, but just based on a field content?

Thanks

 

[chilledproduce]

Menu - format - Conditional Formatting (A2k onwards)away you go


Phill