Continuous form, different color background depending on record status
Posted on 2014-03-09
I am showing the a continuous form containing both active and inactive records. This is based on the contents of field 'Active_YN'.
I wanted to put a yellow background on inactive records and white on active records so I tried this in the Current event:
If active_yn=-1 then
me.detail.background = vbyellow
This doesn't work as I had hoped. When an active record is current the entire background of the form is white, when an inactive record is current, the entire background of the form is yellow.
I want the user to look at a continuous screen with multiple records showing. The inactive ones would have a yellow background and the active ones would have a white background.
Is this possible ?