Hi!

The solution for you is in that expression you use for dynamicbackcolor. There uis really no reason to change it and put the same color both for usual controls and current row controls. With the same effect you can use empty string assigned to DynamicBackColor property.

To highlight rows you need do following:

DynamicBackColor = "iif(,,)"
Above expression will be calculated for each row. thus you can make it depended on the field from the cursor used for grid and show rows when condition is .T. by one color and .F. - with another color. Current row highlighting used exactly the same approach, but logical condition is just .T. for current row only.

>Thanks for your reply, yet, it still does not work... I changed the Column7 in the grid to Sparse = .F. I will have to see what other may be interferring with this cell...
>
>However, this is what I have coded in the Save button:
>
>* Authform SAVE ClickEvent
>=TableUpdate(.T.)
>IF changebc = .T.
> ThisForm.SetAll("DynamicBackColor", ;
> "IIF(RECNO('auth') =ThisForm.nGridRecno, RGB(255,255,255),"+ ;
> "RGB(255,255,255))", "Column")
> ThisForm.Grid1.Column7.Text1.BackColor = 65535
> ThisForm.Refresh
> RETURN .F.
>ENDIF
>
>What I am trying to do is changing BACK to "normal" grid by getting rid of the "row" color (just a highlite thing, easier to read across), then highlite the field(s) that has a missing data (with error message) so the user can spot it. I sure would like to leave the "row" color (lite blue) and just highlite the field(s), but I think the "row" color has the control over that (I tested it with a regular background color and the lite blue still overwrite it).
>
>Chuck
>
>>This because text1 control shown only in the one cell (current cell), when all other values shown by the grid itself (using column properties). To show Text1 control in all cells of column, change value of the Sparse property in the column. This should cause your first line work.
>>
>>>ThisForm.Grid1.Column7.Text1.BackColor = 65535 (this does not work)
>>>vs.
>>>ThisForm.Grid1.Column7.BackColor = 65535 (this does work)

Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.