continuous for change coulour of single record

[John thomas]

Hi I have a continuous form based on a orders table and a details sub form
I list all the records in a continuos form in date of order
i need to change the colour of a single record based on the condition of a tick box on the original orders form

 

[James Dudden]

You can use Conditional formatting which you'll find on the Format tab (in Access 2010). You won't be able to colour the whole record though as the conditional formatting only works on fields. If you wanted to colour the whole record then you could do something like adding a large textbox that was positioned at the back and not enabled and then use that.