Changing properties on continous sub forms

[danno28]

I have a continous sub-form which displays a number of records and if possible I would like to change the backcolor of a specific record. Is this possible? at the moment when I apply .backcolor it changes the colour of the speficfied field in all records.

thanks! Dan.

 

[KenReay]

Hi

Which version of Access are you using?

Access97 - no

Access2000 and / or AccessXp I belive theer is an option called conditional formating which will allow you to do this.

Regards

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

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

UK

 

[danno28]

I'm using 2000 and conditional formatting is exactly what I was looking for. Got it working a treat now.
Thanks Ken!