Text formatting

[mlamont]

I need to know how to change the text formatting on a report. What I want to do is, when a field for instance one called Status equals Open, all of the information that relates to that date goes bold. Can anybody help me?

 

[Adrianna]

Okay...if ou're still looking for an answer I will tell you that it truly depends on the version of acces that you are using.

If you're using 2000 or 2002(XP) then in Design view of the form, right click and select "conditional formatting". Then just change the argument to "expression" and type in [Status]=open and change the formatting to bold.
Pretty simple.

If you are using Access 97 it's a little trickier, but not by much( Ihad to ask this question in a forum a while back...it's been a while since I used 97):

You will need to make two [Status] fields....one regular and one Bold. I'm assuming that you'd rather not write code, so this is how I would do it:

First Status Field:
Under Control Source:
=IIF(([Status]=open), [Status],"")
Set Font Weight to "BOLD"

In the other Status field:
Under Control Source:
=IIF(([Status]<>open), [Status],"")
or
Under Control Source:
=IIF(([Status]=closed), [Status],"")
Set Font Weight to "normal"

Lay these two fields on top of each other...with only one label field! If the criteria is not met than the field will remain blank! if the condition is met, then you will see the proper formatting!

 

[Rich]

If your using 97 one field will do just add the following code to the on format event of the detail section
If Me.SomeField= "SomeCondition" Then
Me.MyField.FontBold=True
Else
Me.MyField.FontBold=False
End If