>I have a grid where the first column is a text box, and the other columns are editboxes. I want the backcolor of the editbox to be different if the controlSource (a memo field in a cursor) is not empty. I have the following to achieve that:
>
>
>FOR EACH loCol IN .COLUMNS
>WITH loCol
> .FONTSIZE = 8
> .Header1.FONTBOLD = .T.
>
> IF .COLUMNORDER = 1
> .Text1.DISABLEDFORECOLOR = .Text1.FORECOLOR
> ELSE
> .SPARSE = .F.
>
>** set all appts to have yellow backcolor
> .DYNAMICBACKCOLOR="IIF("+loCol.CONTROLSOURCE+"='',RGB(255,255,255),RGB(255,255,128))"
> ENDIF
>ENDWITH
>
>
>It works fine UNTIL I make the column/editbox Read-only - then the editbox always has a backColor of white.
>
>To help zero in on the problem, I changed one of the columns that had an editbox to be a textbox, and the color for THAT column apprears properly, i.e., looks like DynamicBackColor works properly for columns w/read only text boxes, but not read only edit boxes.
>
>Any help/insight to this problem? TIA. J
Will it help if you set EditBox's
.BackStyle to
0 - Transparent?
----------------------------------
António Tavares Lopes