<div>
Where is this label (header, detail, footer)?<br />
<br />
I don't know about 2010, but 2007 has a Format event associates with each of the above, and I'm sure this functionality is still there with 2010. &nbsp;Use that event to change the backcolor of the label.<br />
<br />
Private sub Detail_Format<br />
<br />
&nbsp; &nbsp; if [somefield] = &quot;abc&quot; Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.YourLabelName.Backcolor<wbr /> = rgb(255, 0, 0)<br />
&nbsp; &nbsp;elseif [somefield] = &quot;def&quot; then<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.YourLabelName.Backcolor<wbr /> = rgb(0, 255, 0)<br />
&nbsp; &nbsp;elseif [somefield] = &quot;ghi&quot; then<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.YourLabelName.Backcolor<wbr /> = rgb(0, 0, 255)<br />
&nbsp; &nbsp;elseif [somefield] = &quot;jkl&quot; then<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.YourLabelName.Backcolor<wbr /> = rgb(255, 255, 0)<br />
&nbsp; &nbsp;else<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.YourLabelName.Backcolor<wbr /> = rgb(255, 0, 255)<br />
&nbsp; &nbsp;end if<br />
End Sub<br />
<br />
You could also use the Switch function, or possibly the Choose function (if the values of the field you want to test are continuous).<br />
<br />
&nbsp; &nbsp; &nbsp;<br />
<br />

</div>


<div>
Hi,<br />
Thank you for the swift reply.<br />
<br />
fyed: The label is in the detail, but which event loads the page? I see &quot;On click, format, dbl click, mouse down, mouse up, mouse move, paint, print, and retreat.&quot;<br />
<br />
DatabaseMX: How do I go about emulating a Label with a text box? When I create textbox and put in an a value X, i get X is not a vaild field name or expression.<br />
<br />
Thank you,<br />
bcarmi
</div>


<div>
&quot;When I create textbox and put in an a value X, i get X is not a vaild field name or expression.&quot;<br />
<br />
In the text box Control Source, you need an expression&quot;<br />
<br />
=&quot;MyLabelCaption&quot;<br />
<br />
include the equals sign ... an surround the text with double quotes.<br />
<br />
mx
</div>


<div>
If you want to use the Format event, click on the &quot;Detail&quot; bar that divides the header from the detail section. &nbsp;Then view the Events tab on the Properties dialog and find the Format event.<br />
<br />
Select [Event Procedure] from the dropdown on that line, then click the &quot;...&quot; to the right of that to view the VBA procedure.<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
On an Access 2010 report, I'm trying to change the behavior of a label (not a text box) to where if data is = 0 in another text box field, then the label changes color.<br />
I'm fairly new to Access 2010 so your help is appreciated in advance.<br />
thank you,<br />
bcarmi
</div>
</div>


Hi,
On an Access 2010 report, I'm trying to change the behavior of a label (not a text box) to where if data is = 0 in another text box field, then the label changes color.
I'm fairly new to Access 2010 so your help is appreciated in advance.
thank you,
bcarmi

Access 2010 - Conditional formatting on a Label

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.