Solved

Continuous forms font color on certain records

Posted on 2004-09-21
2
246 Views
Last Modified: 2013-12-03
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
Comment
Question by:LoveToSpod
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
pique_tech earned 125 total points
ID: 12111311
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
 

Author Comment

by:LoveToSpod
ID: 12111400
Pique

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

Thanks very much...

LoveToSpod
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

623 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