Change Color of Field on Continuous frm based on value

[mckenneyj]

Need to change the forcolor of a field based on the value

Record3 "AmtPaid" = 200.00
Record6 "AmmtPaid" = 0.00
Record8 "AmtPaid" = -50.00

Forecolor of 3 should be vbGreen
Forecolor of 6 should be vbBlack
Forecolor of 8 should be vbRed

So far all the things I have tried change all records to a specific color based on value of first record.

Thanks,
John McKenney
Work Hard... Play Harder

 

[RoyVidar]

If you're using access 2000+ versions, take a look at conditional formatting in the format menu.

Programmatic changes to do conditional formating (access 97) is not easy. If you search these forums you'll probably find some workarounds with labels etc, but I don't know how they work

Roy-Vidar

 

[Terpsfan]

Bill Power has an excellent post on conditional formatting on continuous forms...thread702-661512.

 

[TonyJollans]

Hi mckenneyj,

Most attempts at conditional formatting in A97 have limited success, but in this case (assuming the field is numeric) you should be able to set the Format to something like ..

[

Green

]

0.00;

[

Red

]

-0.00;

[

Black

]

0.00

That will set the colours; the actual nuber format may not be quite what you want, but you can tweak it.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[sbdeaver]

Do you put the information in the formatting of the text box?
Thanks,
Sharon

 

[TonyJollans]

Hi Sharon,

Yes - if you're referring to the format I posted and using 97. If you're using 2000 or later, look at CF as Roy said.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[