Cahnge Font weight in a report

[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

 

[PaulF]

use the Detail's OnFormat Event
If [week] = 40 then
TextBoxName.FontWeight = 700
Else
TextBoxName.FontWeight = 400
End if

PaulF

 

[martaccess]

Thanks Paul

it works well with a constant

but the number 40 in my example is in a Forms...

and it doesnt seem to work with the code i added

If [week] = [forms]![hello].[w3] then

TextBoxName.FontWeight = 700
Else
TextBoxName.FontWeight = 400
End if


thanks again