I have a form. The Data source for this is a table. I want to change colors for certain fields based on the value. Like
col1 col2 col3 col4 col5 col6 cols
aaa abc 123232323 Aa3 AA Aa2 AA
If you notice the value of col4 and col5 are yesterday and today value and same for col6 and col7.
1.How do I write a something
If col4 <> col5 then color=red
2.At which palce in MS access 97 db I put this ?
Sorry I am MS- Access ignorant