Access97 conditional formatting

[AndyFoz]

I am working on Access97 and do not appear to have the 'conditional formating' function available in the format menu.

I am trying to get the backcolour of a control to change if certain conditions are met.

Any ideas how I can do this please?

 

[Rich]

There is no conditional formatting as such in 97. You can use an If statement something like If Me.YourField >1 Then
Me.YourField.BackColour= Whatever
unfortunately if you use this method on a continuous form all the fields refered to will change colour. You can cheat a little with a pseudo type of conditional format I have an example which may be of use.
HTH

 

[AndyFoz]

Thanks for that Rich.
I am glad it was not just me being stupid and not being able to spot why all the fields were changing colour.

I would be more than grateful of you could email me the code you refered to in your posting.

My email address is afoster@ikigroup.com

Thaks again.

Andy

 

[asp_learner]

Hi Rich,

I would like that code for conditional formatting too. I am still having trouble. I tried everybody's suggestions. I also have Microsoft 97 so I don't have the conditional format as a property.

Thanks,
Eva