This sample db demonstrates highlighting of desired row in a datasheet. This can 
be useful in a large datasheet, where, while editing a particular record, the user is 
required to move to some other record (for reference or copying etc) and then move 
back to the original record for continuing the editing action. 

On double clicking any field in the datasheet, the corresponding row gets 
highlighted. Any other row that might have been highlighted earlier, reverts to 
normal state (only one row remains highlighted at any given stage).

Once a row is highlighted, it remains highlighted till some other row is double 
clicked. (If existing highlight on a row is to be removed without highlighting another 
one, simply double click it again).

Versions - Access XP & 2K (In Access 2000 File Format)
References - DAO 3.6

Download Access XP & 2K:  http://www.rogersaccesslibrary.com/forum/uploads/37/AnchorRowInDataSheet.zip - uploads/37/AnchorRowInDataSheet.zip