Conditionnal formatting for a detail line in access 97

[martaccess]

Hi

i want to change the font weight of the detail line if a encouter a certain number...


Detail
Ex: my line : [week] [description] [product]

If the [week] number of the detail line = 40 then put the font weight to Bold for the entire line

thanks

 

[Databaseguy]

Put this in the on format event of the report.

if Week > 40 then
me.week.font.bold = true
End if Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy