Karen, That works great. I never thought of that approach. That really gives me some other ideas to try. Thanks.
Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, August 01, 2012 10:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB GRID specific row color How about if the row is RED to begin with? Add a computed column to your table (that's the way I usually do it): RowColor=(IFNULL(fieldname,'RED','WHITE')) TEXT 5 Then in your DBGrid, look for the "row background color field" and select that column. When the field is filled in and you refresh the table, the color will refresh with it. Karen In a message dated 8/1/2012 10:03:11 AM Central Daylight Time, [email protected]<mailto:[email protected]> writes: I use DB GRIDs regularly for data entry (grid on bottom of screen, top half are the editable fields for whatever row is selected). User can add rows with an onscreen button. The table might have 5,000 rows, but the DB GRID might only use 5 rows for a specific person. Rows 1,2,4, and 5 might be complete with Row 4 having one NULLed field. The system will not allow Row 6 to be added until Row 4 is completed. A Pause message will pop up saying ‘incomplete rows exist’. I can make the missing fields for Row 4 turn RED by simply moving to Row 4. What I would like to do is change the color of the specific DB GRID row needing to be fixed when the user hits the ADD or EXIT buttons. I have had several people claim they did not see the empty DB GRID row even when the empty row is 1 of 2 rows right in front of them. Next set of DB GRID info may use 8 rows or 1 row. Tried various PROPERTY options, but so far nothing effects a specific row. Any suggestions?
