Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-02-22
2
Medium Priority
?
302 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
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

564 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