Expression in Report to change Font

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me if
1) I can use the Expression builder to change a text value's font (say
color) in a report given the condition the text is equal to a certain value?
2) if so, how?

I'm new to access and I this Expression Builder is something I just can't
seem to figure out.

Thx, Dj
 
I never use the expression builder myself as I find it very unfriendly.
You don't need to use it if you know the syttax of the command you want.
But instead you can do what you want in the FORMAT event for the report
section.
You can set any format property, eg.:
If <condition> Then
Me(control).Fontname = "Arial"
Me(control).Fontsize = 6
end if

Dorian
 
Can someone tell me if
1) I can use the Expression builder to change a text value's font (say
color) in a report given the condition the text is equal to a certain value?
2) if so, how?

I'm new to access and I this Expression Builder is something I just can't
seem to figure out.

Thx, Dj
Click to expand...

If you are using Access 2000 or newer, just use that control's
Conditional Formatting property.
In Design View, select the control. Then click Format + Conditional
Formatting.
Set the Condition1 drop-down to
Field Value Is
In the box alongside select the appropriate operator and enter the
value.
Pick whatever formatting you want and click OK.
 
mscertified
Thanks for the suggestion. At the risk of sounding really really stupid,
can you tell me where to find the FORMAT event for the report section. :-)
Thx, Dj
 
I figured it out. Thanks!!!

mscertified said:
I never use the expression builder myself as I find it very unfriendly.
You don't need to use it if you know the syttax of the command you want.
But instead you can do what you want in the FORMAT event for the report
section.
You can set any format property, eg.:
If <condition> Then
Me(control).Fontname = "Arial"
Me(control).Fontsize = 6
end if

Dorian
Click to expand...
 
Back
Top