continuos subform 3

[mikeba1]

I have a main form with a tabular subform.
With the on current event on the subform I am trying , dependent upon a field within the sub form, to change the colour, however the colour only changes to the first record and the remaining records show that colour,and not the colour they should be.
If i changed the sub form to columnar, the colour changes for each record.

Any ideas gratefully received.

 

[MajP]

google conditional formatting.

 

[mikeba1]

Could you explain

 

[MajP]

http://lmgtfy.com/?q=conditional+formatting+access

 

[PHV]

Use conditional formatting to change the colour of the controls depending on the value of a field.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mikeba1]

Thanks chaps,just what I needed.

 

[dhookom]

MajP deserves a star for pointing Mikeba1 in the right direction without doing all the work for him ;-)

Duane
Hook'D on Access
MS Access MVP