Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Continuous forms font color on certain records

Hi,

I have a form which uses continuous forms to show a list of records. I also have an unboud textbox that calculates a sum of values relating to the record displayed... Looks like this:

FormName = frmPIOSelector

CampaignName           IORefNo              Text2
aaa                               197                  2
bbb                               285                  5
ccc                                524                  0

I need the campaign name in the list to be in redfont if the value of Text2 = "0".

Can anyone supply me with the correct code, and tell me what control and event I should put the code into...

Cheers

LoveToSpod


0
LoveToSpod
Asked:
LoveToSpod
1 Solution
 
pique_techCommented:
In design mode, click on the textbox you want to change the formatting for.  Then click on Format in the listbar at the top and select "Conditional".  Choose "Expression Is" from the dropdown on the left, then in the field to the right type [Text2]=2.  Change the color of the font toward the bottom right of the Condition 1 box.

Hope this helps.
0
 
LoveToSpodAuthor Commented:
Pique

Thanks, I have never used conditional formatting in Access before!!

Thanks very much...

LoveToSpod
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now