Conditional formatting

[gg]

I conditionally formatted the back color of a field based on the value of another field. Works fine when the form is stand alone. When the form becomes a sub form, the conditional format quits working, as if not there. Any fix or is this a fact of life for conditional formatting? (Using Accesss 2000 with W2000. Thanks for rapid fix on my other question.

 

[wiklendt]

your path to the control on the form need to change. access follows the "full path" of a form control and subbing them makes a difference.

here's a really good reference on how to refer to controls in various scenarios. i can't remember where i downloaded it from, but gee it's helped me a bundle!

 

[wiklendt]

whoa... sorry, just noticed that post is 7 years old! i hope you got your problem sorted a lot sooner than that

 

[missinglinq]

Things must be slow, down under, for you to be wandering thru 7 years old threads!

 

[wiklendt]

i was specifically looking at threads that "gg" started (i had replied to gg's "how do i make a new questions" post). gg only had ~5, so, without looking at the dates i assumed he was a recent addition to the community and i saw one was left unanswered... poor fella

 

[boblarson]

i was specifically looking at threads that "gg" started (i had replied to gg's "how do i make a new questions" post). gg only had ~5, so, without looking at the dates i assumed he was a recent addition to the community and i saw one was left unanswered... poor fella

that is funny. But I think they were here recently for something else.