Set Backcolour on a subform

[aexley]

Good Morning.

I need to set the backcolour of a control on a subform in 'Continuous Forms' depending on whether the value of the subform control matches the value of a control in its master form.

E.g.

Main Form Control Value = 226

Subform control values =

0
23
327
0
226 <---- I need the back colour to be different.
87
226 <---- ditto

I can't get the control to change individually, it's all or nothing.

Any ideas?

Thanks in advance.

aexley

 

[KenReay]

Hi

Which version of Access?

If it is Access97, you cannot do it

If it is Access2000 or AccessXP, then look at conditional formating Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[aexley]

Using Access 2000. Will look at conditional formatting,

Thanks

aexley

P.S. Is anybody else having problems with pages not loading on this site or is it just me?

 

[KenReay]

Hi

No - I am having same problem Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK