Text Box formatting Question

[Ray1127]

I have a report in MS Access 2003. The query that the report is based on has a numeric field. The requirement is that if that numeric field exceeds the value 9.9 the value should be bolded.

In the Format event of the Detail Section I have the following line of code.

If me.txtclinicalvalue > 9.9 then me.txtclinicalvalue.fontweight = Bold else me.txtclinicalvalue.fontweight = normal

I set a breakpoint on that line of code and it does exactly what I want. However when the report completes and is displayed on the screen or printed that value is not bolded. What am I missing?

 

[dhookom]

What report view are you using and why are you not using conditional formatting?

Duane
Hook'D on Access
MS Access MVP

 

[Ray1127]

Duane, because I hadn't used conditional formatting for a long time and it didn't occur to me until after I posted yesterday. Used it to accomplish what I was trying to do. Thanks anyway