[AccessD] Fw: Conditional formatting in Access 2010 report

As usual... nevermind! :) You guys are magic -- it works everytime!

Susan H. 


I'm trying to apply a conditional format to a report control using Access 2010. The feature offers two methods -- conditional formatting based on the current value and conditional formatting based on an expression. I was hoping I could use an expression to refer to another value in the same record. For instance -- if the InStock value goes below a certain number, display the Reorder value in red -- or something like that. I can't figure out -- is this even possible? 

Susan H.