<div>
HI,<br />
<br />
When you are creating a Formatting Rule underneath the Standard Color by thee Fill button you can choose More Colors<br />
<br />
Regards
</div>


HI,

When you are creating a Formatting Rule underneath the Standard Color by thee Fill button you can choose More Colors

Regards

<div>
You can use the form Open event to run code similar to<br />
<br />
With forms(&quot;forms1&quot;).Controls(&quot;<wbr />Textbox1&quot;)<wbr />.FormatCon<wbr />ditions(1)<wbr /><br />
&nbsp; &nbsp; .BackColor = RGB(255,255,255)<br />
&nbsp; &nbsp; .FontBold = True<br />
&nbsp; &nbsp; .ForeColor = RGB(255,0,0)<br />
End With
</div>


You can use the form Open event to run code similar to

With forms("forms1").Controls("Textbox1").FormatConditions(1)
    .BackColor = RGB(255,255,255)
    .FontBold = True
    .ForeColor = RGB(255,0,0)
End With

<div>
<div class="content wysiwyg-content">
I want to be able to set the conditional formatting - Fill/Back Colour on a text box. The selection of colours is limited and I am looking for a lighter colour of red. Is there anyway to add colours to the selection?
</div>
</div>


I want to be able to set the conditional formatting - Fill/Back Colour on a text box. The selection of colours is limited and I am looking for a lighter colour of red. Is there anyway to add colours to the selection?

Access conditional formatting set fill colour

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.