[AccessD] Fw: Conditional formatting in Access 2010 report

Oh, I'm sorry. The expression I was using was fine -- it worked exactly as I 
expected once I rename the controls. The feature gets lost if you use the 
default control names, which are the same as the underlying field names.

I haven't worked in Access in a while and it took me a minute to remember 
that.

Susan H.


>
>
> But what is the Answer ?
>
> Please share.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Thursday, September 23, 2010 9:46 AM
> To: Access Developers discussion and problem solving
> Subject: [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.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com