How to Make the particular text field BOLD based on the Value from query (1 Viewer)

[balaryan]

Hi All,

Good day. I am using MS Access 2007 and have a report which display the list of values (say 10 fields) from the basic SELECT * FROM table query.

I need to dynamically set the BOLD based on the particular value for the fifth field which was assigned from Query. if it doesn't match it should display normal.

E.g
If Field_5 = "Agent" then
Field_5.FontBold = True
Else
Field_5.FontBold = False
End if

I tried the aforementioned code and it dont work. ALso i tried achieve it using below listed options.

Me.Field_5.FontBold = True
Field_5.Properties("fontweight") = 700

But nothing worked. Kindly assist me.

 

[Minty]

I think you need the me qualifier ;

If Field_5 = "Agent" then
[COLOR="red"]Me.[/COLOR]Field_5.FontBold = True
Else
[COLOR="Red"]Me.[/COLOR]Field_5.FontBold = False
End if

 

[Gasman]

Sorry, just noticed that you mention report, not form.

Have you place the code in the correct event.?

From this link http://www.access-programmers.co.uk/forums/showthread.php?t=210793

it should be the Format event for the detail?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

 

[balaryan]

Thanks Gasman. Your information saved me in right time. it works.

Thanks a ton my friend.

 

[Gasman]

Thanks Gasman. Your information saved me in right time. it works.

Thanks a ton my friend.

Happy to be able to help.

 

[CJ_London]

you can also use conditional formatting