<div>
ahhh...too easy. &nbsp;I dint think of that. &nbsp;thank you
</div>


ahhh...too easy.  I dint think of that.  thank you

<div>
<div class="content wysiwyg-content">
Hello, how can I change the font color from black to RED for the word &quot;Past Due&quot; below? &nbsp;see the bold part. &nbsp;The below is in a query design builder window:<br />
<br />
PastDueOrPendingSWITCH: Switch([Due Date Per Docs]&lt;Date() And <b><u>[Completed] Is Null,&quot;Past Due&quot;</u></b>,[Due Date Per Docs]&gt;=Date() And [Completed] Is Null,&quot;Pending&quot;,[Completed]<wbr /> Is Not Null,&quot;Completed&quot;,True,&quot;&quot;)
</div>
</div>


Hello, how can I change the font color from black to RED for the word "Past Due" below?  see the bold part.  The below is in a query design builder window:

PastDueOrPendingSWITCH: Switch([Due Date Per Docs]<Date() And [Completed] Is Null,"Past Due",[Due Date Per Docs]>=Date() And [Completed] Is Null,"Pending",[Completed] Is Not Null,"Completed",True,"")

Change font color in a SWITCH statement

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.