Conditional Formatting in a Continuous Form in Access 2007

[jdashm]

Thanks for the assistance. However, it seems that the Conditional Formatting option now is working.
Why it was not working before I have no idea other than it is Microsoft Access. The logic of this logical application escapes me sometimes.



So... bottom line I believe (correct me if I am wrong) is that the VBA code could not work in a Continuous Form layout but Conditional Formatting did.
Thanks to everyone who responded.

[pbaldy]

Correct, VBA can work in a report but not a form. Reports have events that fire for each record you can use.

[Micron]

Sorry, let me try again. If I put conditional formatting on a control, using vba or the ribbon (it does not matter which), and I want the control to go red if "qty >10", then this condition applies to all the records for that field. That is, I cannot limit this to rows 7 and 10 for whatever reason but not affect every other row. If record 15 is also >10, I cannot help but make it red too. This is a characteristic of continuous forms as the poster alluded to. Perhaps I have misinterpreted the original question which is

it seems to disable those fields in all the records instead of just the current one

and I might be barking up the wrong tree because the first part of the post indicates that visibility is what is trying to be set. I'm not sure that visibility is something you can control with CF anyway, because I don't use CF very often.
Usually, what people want to do is apply some condition on a control based on other characteristics within a record, but they can't understand why it affects all the controls in that field in all the records where the condition applies. So the poster is saying he wants some controls to be visible and some not, and I'm saying whatever you do to a control propagates throughout all the records. Sorry if I wasn't clear, and I really appreciate your comment about my knowledge, the level of which I do place below yours and several other contributors here. If you don't agree, I suggest you PM me if you think we might be hijacking this thread.

[pbaldy]

I would agree with what you describe. A condition of ">10" will affect all records that meet that criteria, not just some.

For the record, you technically can't set the visibility of a control with CF, but you can kinda fake it by setting the fore color the same as the back color. Other settings would determine how well that works.