Subform Textbox Properties

[Robert_DubYa]

I would like to use some VB to do a simple comparison within a sub form that
changes the back color of the subform cell to red. I have tried to manually
change the subform property to red, but that entire column still stays a
normal white. It appears that while in the data sheet view the back color
does not change even if you change the property for that text box. Any
thoughts on how to change the back color while in datasheet view?

thanks,
Robert

 

[Pat Hartman]

You need to use the conditional formatting feature. Open the subform in
design view, choose conditional formatting from the format menu. You have
three options plus the default. Hopefully that will be enough.

 

[Robert_DubYa]

Pat,

This worked like a charm. Even easier than coding.

Thanks!!!!!!
Robert