Row Colour

I have a continious form set up with a query and the results are shown in the 'Detail' section using text boxes.

I would like to be able to set the 'row' colour to a colour when any of the text boxes have got focus in that row.

This is purely for the users ease of use, but no matter how hard I try I cant get anything to work.


( Do the text boxes have a value im not aware of for each row value?)

Access forms do not format the same way as Access reports! . One possible way would be to set a row value whenever a field in the row has got focus (unset when lost!) and use conditional formatting (Form design select Format/Conditional Formatting)

Good luck!

Attached is a sample database that you can use to see how to highlight a row when the row has the focus. This sample uses the Northwinds Products table and a continuous form displaying the products.

Good luck,
lwells