MS Access - Report formatting

[Bungle99]

Can anyone tell me an easy way to produce a report that will show figures in different formats dependent on the value.

For Example a 7 coloumn report name and six values. If a value is greater than (say) 100 then that figure is shown in bold.

Fred 80 70 65 105 25 99
Jack 90 22 88 78 135 110

So Fred's 105 and Jack's 135 & 110 would be shown in bold (or even another colour/both)

Can this be done in the report or would it require a query?

Many Thanks

 

[CosmoKramer]

In the On Format event for the section where these fields are located, put code like this for each field you would want to be bold (of course, changing to your field names):

If Me.txtField1 > 100 Then
   Me.txtField1.FontBold = True
Else
   Me.txtField1.FontBold = False
End If

Repeat this for each field and you should be all set.....

 

[Bungle99]

CosmoKramer

Many thanks - worked like a dream !