Reduce font size

(0) Share

Report

Posted on by Community Member

Hi,

How can I change this to say, if there is greater then 9 letters, reduce the font size by 2, and again if theirs greater then 18 letters, reduce it by so many.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Mohana Yadav 60,999 Super User 2025 Season 2 on at

Like (1)

Report

I dont think it is possible

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Is there any way of saying Every time there's a '/' reduce the font size?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

May be you can look at Font size expression

Or

You can create two text box and make it visible based on condition

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi,

We usually dont do it, but you can try the following links.

stackoverflow.com/.../how-to-auto-reduce-font-size-if-it-is-too-long-over-fixed-textbox-in-rdlc-report

social.msdn.microsoft.com/.../change-font-size-dynamically

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you that's very useful!

This top line does work ..

=iif(len(Fields!ProdOrderNo.Value)<9, "24pt", "16pt")

How can I adjust this if it's possible to include..

=iif(len(Fields!ProdOrderNo.Value)<18, "24pt", "8pt") but include it in one line as currently it doesn't pick up the second line.

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report
=switch( iif(len(Fields!ProdOrderNo.Value)<9, "24pt", "16pt"), iif(len(Fields!ProdOrderNo.Value)<18, "24pt", "8pt") )

Try this. By the way, do test, because I did not test it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks again, unfortunately it doesn't appear to have worked.

Was this reply helpful? Yes No
Verified answer

Rajasekhar@MS 5,569 on at

Like (1)

Report

Hi

You can try below

=iif(len(Fields!ProdOrderNo.Value)<9, "24pt", iif(len(Fields!ProdOrderNo.Value)<18, "16pt", "8pt"))

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There isn't a CHOOSE function available?

iif (length(field) < 18, choose(length(field),24,24,24,24,24,24,24,24,24,20,22,20,18,16,14,12,10,8,6),6) or whatever the format is...

would give finer control.

Was this reply helpful? Yes No