Forum Discussion

NehaBansal's avatar
NehaBansal
Qrew Member
4 years ago

Increase font size of field value and field name (Formula-Numeric field with 2 decimal place percent value)

I tried your solution to increase the font size of value a formula - numeric field is providing by using an additional rich text field and adding following formula: "<span style='font-size: 24pt; t...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
No, as far as I know, you cannot increase the field name size.  The best you can do is to suppress the field name using the form settings and in place put a Rich Text formula field.  But I think that field would be pretty far away from the field value ....

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
NehaBansal's avatar
NehaBansal
Qrew Member
4 years ago
Thanks Mark. This all worked. One small query ...My original field is a formula numeric field showing the value as percent with 1 decimal place. 

I am trying to match the value by using the following code:
"<span style='font-size: 22pt; text-align: left'>" & "Overall Score (Element Quality Review %):" &" </span>"

& var number Value = ([Element Quality Review % _Q_])* 100; // this is here only because you say that this is a Percentage.
//var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");
var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");

var text Thousands = If($Value>=1000,ToText(Int($Value/1000)));

var text Hundreds=Right(ToText(Int($Value)),3);

var text NumberInTextFormat = If($Value<0, "- ") &List(",",$Thousands,$Hundreds) & $Decimals;

"<span style='font-size: 24pt; text-align: left'>" & $NumberInTextFormat & "%" &" </span>"


But my value of 95.4 is being shown as 95.36 and when I am trying to change  "var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");" to "var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),1),1,"0");"...it is converting the value to 95.6. Please advise

------------------------------
Neha Bansal
------------------------------