When I have to do something like that, I try to use a form variable since they are evaluated only for the focused row. Would it be good enough to put a red variable with the word "negative" or 2 red parenthesis around the field if it is negative? Something like: set var vNegText = (IFLT(column, 0, 'NEGATIVE', ' '))
Karen -----Original Message----- From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Mar 4, 2015 4:15 pm Subject: [RBASE-L] - negative highlighted in scrolling region Scrolling region with a variable vemptime that calculates the time for a process. The driving table of this form is different than the scrolling region. Sometimes when importing into this table, the times are messed up and this var becomes negative. (The variable is based on the punch in punch out times). My code shows a PAUSE clause then forces the cursor into the scrolling region if the punch out time is less than the punch in time. What I want now is the offending var field to change color because it is negative. Since there are multiple rows and many of them will be fine, I only want to var field that is negative to change. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]]
