Change Control on Subform 1

[ca268339]

I have a continuous subform that is populated from a query dynamically created by the master form. On each of the lines in the subform I have an object that I would like to change the background color on depending on the amount. I normally would use the onCurrent property to set the control on the form, but that only works for the entire form. Is there an event that processes for each detail line? Any suggestions on how to dynamically modify the controls on the subform?

 

[rafe]

I've got a question for you...

Are you using A2K? The only version I know...

If so then, look at the "Conditional Formatting..." under the "Format" menu, when you have the conrol in question selected in design view.

If you don't have A2K then you need EXPERT help ;-)

 

[ca268339]

Thanks for the great suggestion, that solved the problem and eliminated the need for a report. Just out of curiosity, is it possible to access the control that changes the format from code?

 

[rafe]

Certianly is (Good question)

Check out the "FormatConditions" property under help. It's just slightly more complicated than the usual property settings. There are samples too.

Happy coding!