That may be the way I need to go but I would rather have a way the guilty row itself would be pointed out. Thanks for the suggestions.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Thursday, March 05, 2015 3:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region You could design form expressions modelled like what I had below and locate the variables on the row, maybe in bold red. Variable labels have the ability to blink, so you could add that too! Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Thu, Mar 5, 2015 3:23 pm Subject: [RBASE-L] - Re: negative highlighted in scrolling region Karen, I have been away from the computer for a while. What I want is if any of the rows, not just the focused row, are negative then: 1) A warning box would come up. I have this completed. 2) The cursor focuses on the detail section. I have this completed. 3) The offending row in the scrolling region would do something to get the attention of the user. Number three is what I need. It would be great if the cursor would not only jump to the detail section but to the offending row. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]>] From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Karen Tellef Sent: Wednesday, March 04, 2015 4:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region 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]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[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]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>]
