<div>
Here's a good link to that BTW with screen shots and step by step:<br />
<br />
<a href="http://office.microsoft.com/en-us/access-help/change-the-appearance-of-a-control-by-using-conditional-formatting-HA010208133.aspx" rel="ugc">http://office.microsoft.com/en-us/access-help/change-the-appearance-of-a-control-by-using-conditional-formatting-HA010208133.aspx</a><br />
<br />
Jim.
</div>


Here's a good link to that BTW with screen shots and step by step:

http://office.microsoft.com/en-us/access-help/change-the-appearance-of-a-control-by-using-conditional-formatting-HA010208133.aspx [http://office.microsoft.com/en-us/access-help/change-the-appearance-of-a-control-by-using-conditional-formatting-HA010208133.aspx]

Jim.

<div>
<div class="content wysiwyg-content">
I am showing the a continuous form containing both active and inactive records. &nbsp;This is based on the contents of field 'Active_YN'.<br />
<br />
I wanted to put a yellow background on inactive records and white on active records so I tried this in the Current event:<br />
<br />
If active_yn=-1 then<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.detail.background = vbyellow<br />
else<br />
&nbsp; &nbsp; &nbsp; &nbsp;me.detail.nackground= vbwhite<br />
endif<br />
<br />
This doesn't work as I had hoped. &nbsp;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.<br />
<br />
I want the user to look at a continuous screen with multiple records showing. &nbsp;The inactive ones would have a yellow background and the active ones would have a white background.<br />
<br />
Is this possible ?
</div>
</div>


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
else
       me.detail.nackground= vbwhite
endif

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 ?

Continuous form, different color background depending on record status

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.