Highlight an entire row in a datasheet

[Howiee]

Hello,
Is it possible to highlight an entire row in a datasheet when a single field has focus. E.g I have two columns in my datasheet One called Store and the other Price. I want my datasheet to highlight (change back colour) the entire row i.e both Store and Price when either a particular Store or Price have the focus.
I have played around with the the Conditional Formatting settings but can only get it to highlight one field at a time.

Any help would be much appreciated,

Mark.

 

[hsitz]

I think I've done something similar to what you want by using the SelectRecord action. When you select a record in a datasheet the entire row becomes highlighted.

This method will probably require quite a bit of reworking the code in your form. For example, I enabled key preview on my datasheet form and then trapped keystrokes. Many keys I would simply not recognize at all. For keys (like up arrow and down arrow keys) that I wanted to enable to allow the user to move through the datasheet, I attached small procedures that would always end up doing a select record action after the move so that the entire record would always be highlighted. -- Herb

 

[Howiee]

Thanks for your help Herb!
The problem with using SelectRecord is it will mean the user will not be able to alter any of the cells i.e. if the down button is pressed to select the next set of records down then the user cannot change the cell that he has down keyed to because the Entire Record has been selected. So what I need (sorry I should have put this in my initial question) is when a single cell is selected it makes the row that the cell is on a different color, but still gives me the functionality to change the data in a particular cell.

Mark.