Changing Back colour of current record control

[Costefran]

Hello

Can anyone advise if I can change the back colour of a current record on a subform set to continuous forms

For example I have a subform with a control called "Quantity" and I am changing the backcolour to green through

Me.Quantity.Backcolour=65280

This changes Quantity to green on all records on the continuous form


I would like to only change quantity on the current record so have tried

Me.CurrentRecord.Quantity.Backcolour = 65280

This does not work but wondered if there was some suitable way of achieving this

Please note I had posted this on the end of an answer to another question so apologies if you have seen this already

Many Thanks

 

[Remou]

You can use conditional formatting and Field Has Focus.

http://office.microsoft.com/en-gb/access/HA010448511033.aspx

 

[Costefran]

Many thanks