Locking rows in Datasheet view

[Massoud]

Hi every body.
Is there any way so we can lock one or some of the rows of a form which is viewed as a datasheet, depending on the value of one of the fields (or change other properties such as text color) ?
I have to do this in Access97. But if it's impossible in 97 please let me know in other versions.
Thanks

 

[Pat Hartman]

Since only one row at a time is current, you only need to worry about that row. Put whatever code you need in the Form's Current event. The Current event is evaluated each time the record pointer is moved. In a continuous or datasheet form, there is only one set of properties so if what you modify affects visibility, the property setting will apply to EVERY row. For example, if your code hides fld2 if fld1 is True then if fld1 is True for the current record, fld2 will be hidden on all the rows. If fld1 is False for the current record, fld2 will be visible on all the rows.

 

[Massoud]

So it seems there is no way to change the color of some specific row.