Something like:
frmMyForm.grdGrid1.SetAll("DynamicBackColor", "IIF( EMPTY( MyTable.MyMemo), ;
RGB(255,0,255), RGB(0,255,0))", "Column")
Not tested. This won't change the button colour but rather the whole row.
HTH
Terry
>Good morning!
>
>I have a simple table displayed in a grid. One of the fields is a MEMO field that may or may not contain notes. Screen space is limited so I would like to have a small "Notes" button in one column that will display with the 'fontbold' or 'enabled' property set to true when there are notes in the underlying memo field of that record. Clicking the Notes button would simply bring up another form with the notes in it.
>
>Is this possible? I know you can set dymanic row colors but I can't figure out how to accomplish what I'm wanting here.
>
>Big thanks in advance!
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.