Solved

Continuous forms font color on certain records

Posted on 2004-09-21
2
244 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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 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