<div>
I prefer to use conditional formatting.
</div>


<div>
Th OP is asking about a label.<br />
<br />
I guess it could be changed it to a textbox with properties to make it look like a label in order to use CF.
</div>


Th OP is asking about a label.

I guess it could be changed it to a textbox with properties to make it look like a label in order to use CF.

<div>
Was not sure, the title says &quot;label&quot;, but then in the text, the OP used fields. &nbsp;Thought I'd throw our that option too.<br />
<br />
Dale
</div>


Was not sure, the title says "label", but then in the text, the OP used fields.  Thought I'd throw our that option too.

Dale

<div>
Yeah... either way, its a good option.
</div>


<div>
Thanks, that works nicely.<br />
<br />
(I DID mean &quot;label&quot; .... excuse my lack of correct terminology ... I am a victim of being self taught by a lazy teacher !!)
</div>


Thanks, that works nicely.

(I DID mean "label" .... excuse my lack of correct terminology ... I am a victim of being self taught by a lazy teacher !!)

<div>
<div class="content wysiwyg-content">
<br />
Hi again,<br />
see this line below.<br />
Me.ReportedByID.BackColor = vbRed<br />
<br />
Instead of vbRed I want to be able to have a variable.<br />
So, for instance, I want to be able to set of fields to a different colour without have to amend multiple fields. &nbsp; How do I do this??
</div>
</div>



Hi again,
see this line below.
Me.ReportedByID.BackColor = vbRed

Instead of vbRed I want to be able to have a variable.
So, for instance, I want to be able to set of fields to a different colour without have to amend multiple fields.   How do I do this??

Quickie !  Making a variable colored 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.