Solved

Continuous forms font color on certain records

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

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!

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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…
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.

710 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