>>>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