Solved

If GROUP="XX" the Make Selling Price GREEN (Continous Form)

Posted on 2011-02-22
2
292 Views
Last Modified: 2012-05-11
I have a simple continuous form.

It shows 3 fields (1) product code  (2) group  (3) selling price.

The form header has no data - just headings.  Therefore not relevant.

How do I : Display the selling price in GREEN where the group ="XX".

(Where so I put this code?  Do I relate it to an EVENT on the form??)


0
Comment
Question by:Patrick O'Dea
[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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34955178
in the design view of the form
select "selling price"
format > conditional formatting

expression is   [group]="XX"

select the color from the pallete, click ok
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 34955220
Thanks again

I had not realised that Conditional FOrmatting supported "expressions".
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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 …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

615 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