Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing backgroundcolor of some rows in a grid!
Message
From
29/01/1999 09:04:21
 
 
To
29/01/1999 08:07:18
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00181704
Message ID:
00181750
Views:
8
>>>Hello.
>>>
>>>I have a Grid which is populated with a SQL-statement.
>>>In the SQL-statement there is a memo field.
>>>I want to change the backgroundcolor on every row where
>>>!EMPTY(memofield). I also want to display a button on these
>>>rows in a column so you can click that button to display the
>>>memofield.
>>>
>>>Any ideas, I'm kind of stuck.
>>>
>>>/Magnus
>>Hi,
>>
>>What you want should be possible. You would use the DYNAMICBACKCOLOR property to highlight the memos, and then in another column use the DYNAMICCURRENTCONTROL property to display the button.
>>
>>I've just tried this and it should work (I wasn't sure about the button).
>
>Hi Mark,
>
>How do you get a button to display in a grid? I just can't get it to work.
>I've done exactly as you described.
>By the way the backgroundcolor works fine, thanks.
>
>/Magnus

Just drop the button in the grid column that you want it to display on. If you want the button to show on every row, and not just the current one, set Column.sparse to .F.

To have the button show only on rows where the memo is not empty, put code in the column.DynamicCurrentControl property something like the following:

IIF(!EMPTY(MyTable.Mymemo),"MyButton1","Mytext1")
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform