Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid, Showing a Group of Records in a Different Color
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00266193
Message ID:
00266496
Views:
20
That helped! I appreciate it greatly. Thanks.

>Try storing the InvoiceNumber to a property in the form. Then change the test if the IIF() to something like
>
>"IIF(<b>thisform.InvNo == MyCursor.InvNo</b>, RGB(255,0,0), RGB(255,255,255))", "Column")
>That should color only the rows that match.
>
>hth
>>I have a frm which comes up with a grid showing ALL orders with ORDER SET TO Invce number. On the same form, I have provided the user with a txtBox for typing in an Invoice number to enable jumping directly to that invoice number. In this system, there will be several records with the same invoice number but different line items in each record.
>>
>>I am wanting to be able to highlight all of the records in the grid that match the invoice number the user has typed into the Search txtBox. Is there a way to do this? Previously, I have highlighted a single record in a grid with the code which follows...
>>
>>
>>* Highlight Selected Record in Red, rest of records normal white BackColor.
>>ThisForm.Grid1.SetAll("DynamicBackColor", ;
>>"IIF(RECNO()=mSelectedRecord, RGB(255,0,0), RGB(255,255,255))", "Column")
>>
>>
>>I know I could SET a FILTER and accomplish my purpose, but for this form, I would rather highlight as explained above. Any help is appreciated. TIA, Chuck.
Chuck Henry
Previous
Reply
Map
View

Click here to load this message in the networking platform