I have a formula to fill text box when the user enters a specific number. I'm trying to figure out how to remove the fill color if there is no number entered?
If I use a formula like this:
If(Value(Self.Text)>3, Red, Value(Self.Text)<1, Red, White)
it fills in the text box when there is no data entered yet. Is there a way to fix this? Thank you.
Solved! Go to Solution.
This is because the Value of blank is zero in this case, which is less than 1.
Quick fix is:
If(IsBlank(Self.Text), 'blankColorHere',
Value(Self.Text)>3, Red,
Value(Self.Text)<1, Red,
White
)
I hope this is helpful for you.
This is because the Value of blank is zero in this case, which is less than 1.
Quick fix is:
If(IsBlank(Self.Text), 'blankColorHere',
Value(Self.Text)>3, Red,
Value(Self.Text)<1, Red,
White
)
I hope this is helpful for you.
It worked, thank you!
User | Count |
---|---|
254 | |
112 | |
92 | |
48 | |
38 |