sql - How to Make the particular text field BOLD based on the Value from query -

good day. using ms access 2007 , have report display list of values (say 10 fields) basic select * table query.

i need dynamically set bold based on particular value fifth field assigned query. if doesn't match should display normal.

e.g  if field_5 = "agent" field_5.fontbold = true else field_5.fontbold = false end if

i tried aforementioned code , dont work. tried achieve using below listed options.

me.field_5.fontbold = true field_5.properties("fontweight") = 700

but nothing worked. kindly assist me.

have tried changing field property rich text instead of plain text?

Brazille