dynamically change the property of a text box depending on value.

[thydzik]

How would I set something like this up.

I have a text box named qtyText with the value [qty]
how to I make this text box become bold everytime the qty value is greater than 7?

 

[pbaldy]

Presuming you have A2k or later, Conditional Formatting.

 

[thydzik]

Presuming you have A2k or later, Conditional Formatting.

Okay, so i construct the Control Source using the iff command?
but how exactly do i set that up?

I have tried something like

=IIf([qty]>7,qtyText.FontBold=Yes,[qty])

but it doesn't bold the value, and also how do I seperate multiple statements?

 

[thydzik]

Okay, I did a google search and now understand conditional formating. But what if i want to change the font size? how would I do that?

EDIT: okay I solved this one myself (again)

with an on event in the detail section a macro was created that changed exactly what i was after