Conditional Format Font Size

[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

 

[Marshall Barton]

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?

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.

 

[LCalaway]

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

 

[Marshall Barton]

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

 

[LCalaway]

Thank you for the help.
L Calaway

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.