Solved

Access conditional formatting set fill colour

Posted on 2014-04-02
5
596 Views
Last Modified: 2014-04-03
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?
0
Comment
Question by:Idarac
  • 2
  • 2
5 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39972136
HI,

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

Regards
0
 
LVL 1

Author Comment

by:Idarac
ID: 39972150
Sorry but I don't see it
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39972244
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
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39972247
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
 
LVL 1

Author Closing Comment

by:Idarac
ID: 39976261
Thank you
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now