I've got a simple form with an unbound field, plannedWA, which is set
to 100
a second unbound field, totalWA has a control source of =plannedWA +
1, and one conditional format
expression is [plannedWA]>0

which changes the font to red

in this case, the font should be red, but isn't

is this a syntax problem ?

if I don't put in the [] brackets, access changes the expression to
"plannedWA">0

Try changing the expression to
CDbl([PlannedWA]) > 0

Or simply use
FieldValue > 1

Access is not always good about determining the type of data in unbound
CONTROLS (not fields). 100 could be text or it could be a number, Access will
generally default to text unless there is some other "hint" to help it decide
the value of the control is something different than text.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Roger wrote:

On Sep 29, 6:55*am, John Spencer <JSPEN... (AT) Hilltop (DOT) umbc> wrote:
that makes sense... thanx