Access conditional formatting set fill colour

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?
LVL 1
IdaracAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

In Design Mode right-click your textbox Choose Conditional Formatting add a new rule or edit one
then Click the Fill button to choose your color.

Regards
0
 
Rgonzo1971Commented:
HI,

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

Regards
0
 
IdaracAuthor Commented:
Sorry but I don't see it
0
 
Dale FyeCommented:
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
0
 
IdaracAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.