Larry,
Thanks for the response. Unfortunately it is not a view but a table. This table gets updated as a result of shipping choosing to package orders so it really cannot be a view. The goal of course is NOT to have negatives. Since some orders have multiple products, they may choose an order without seeing all the parts for all the products on the order. That is where the possibility for negatives comes in. We can still un-choose (not really a word) the products so it is not irreversible. I just wanted to have a second way to show the negatives other that the box that pops up. If I went to a DBGRID, I would have a little more flexibility for this scenario, correct? James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Monday, January 23, 2012 8:35 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Variable Listview << SELECT (LISTOF(DISTINCT partnum)) INTO vnprt INDICATOR ivnprt + FROM inv_all_open WHERE availpcs < 0 How do I limit the row color to just the negative rows? >> Here's how: 1. Make sure the relation feeding the Listview is a view, not a table. (I'm assuming from the name inv_all_open that's already true). 2. Add a calculate column to the view that spits out the color you want. For instance: CREATE VIEW inv_all_open (. . ., FontColor) AS + SELECT . . ., (IFLT(availpcs, 0, 'RED', 'BLACK')) 3. On the Properties screen for the ListView, go to the Lookup Settings page. Find the last item on that page, Row Font Color Field. In the drop down, choose the new field you added to the view (in the example, FontColor). Voila! Note that where I used 'RED' and 'BLACK', you can use any of the formats in which R:Base understands colors including RGB to produce any color that the system is capable of displaying. -- Larry
