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
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.
Hi
You can try below
=iif(len(Fields!ProdOrderNo.Value)<9, "24pt", iif(len(Fields!ProdOrderNo.Value)<18, "16pt", "8pt"))
Thanks again, unfortunately it doesn't appear to have worked.
=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.
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.
Hi,
We usually dont do it, but you can try the following links.
May be you can look at Font size expression
Or
You can create two text box and make it visible based on condition
Is there any way of saying Every time there's a '/' reduce the font size?
I dont think it is possible
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (