Conditional Format Font Size

  • Thread starter Thread starter LCalaway
  • Start date Start date
L

LCalaway

Hello-

I am attempting to use Conditional Formatting for the first time. I see
that you can change the color of a font, make it bold, or italicize it. I
do not see a place to make the font larger if a condition is met/not met.
If this change can be made accomplished here, how does one do it? Is there
a better way to handle it aside from creating a second text box?

Thank you.

LCalaway
 
LCalaway said:
I am attempting to use Conditional Formatting for the first time. I see
that you can change the color of a font, make it bold, or italicize it. I
do not see a place to make the font larger if a condition is met/not met.
If this change can be made accomplished here, how does one do it? Is there
a better way to handle it aside from creating a second text box?
Click to expand...


Changing the font size might also change the size of a can
grow/shrink text box, which in turn may invalidate the
section formatting, which then causes . . ..

Use a second text box.
 
I understood the limitations when I asked the question. In the situation
that this would be applied, there doesn't seem to be any limitation. Is
there a way to use the same text box? This would be totally preferable
under the circumstances.

LCalawy
 
Not with conditional formatting or a single text box
ecpression.

However, if you're willing to use VBA in the section's
Format event procedure, then it's very straightforward:

If <some condition> Then
Me.textbox.FontSize = 12
Else
Me.textbox.FontSize = 8
End If
 
Thank you for the help.
L Calaway


Marshall Barton said:
Not with conditional formatting or a single text box
ecpression.

However, if you're willing to use VBA in the section's
Format event procedure, then it's very straightforward:

If <some condition> Then
Me.textbox.FontSize = 12
Else
Me.textbox.FontSize = 8
End If
--
Marsh
MVP [MS Access]


I understood the limitations when I asked the question. In the situation
that this would be applied, there doesn't seem to be any limitation. Is
there a way to use the same text box? This would be totally preferable
under the circumstances.
Click to expand...
Click to expand...
 
Back
Top