Good day, Geniuses
Trying to change the Fill field in a Textbox to white if a ComboBox InputTextPlaceholder value is at the default "Find Items". This process is happening within an existing "If" statement which changes the Textbox Fill to red or green based on a date comparison...
Here is the existing working formula residing in the Fill property of the Text box.
If(DateDiff(DatePicker1.SelectedDate, DateValue(TextPMeterDate.Text), Months) > -12, LightGreen, LightPink)
Thanks for anyone's assistance and time!
Lee_B
Solved! Go to Solution.
IsEmpty(SomeCombobox.SelectedItems)
Put something like this IsEmpty above in an outer condition to see if nothing is selected of a Combobox. Then put your existing condition inside for the no side (not empty) - on the yes side you can put the White color. Check if it helps as starting point.
IsEmpty(SomeCombobox.SelectedItems)
Put something like this IsEmpty above in an outer condition to see if nothing is selected of a Combobox. Then put your existing condition inside for the no side (not empty) - on the yes side you can put the White color. Check if it helps as starting point.
poweractivate! You nailed it... I was trying IsEmpty and IsBlank but couldn't get the syntax to work... Here is the functional code:
If(IsBlank(ComboCalGear.Selected), White, DateDiff(DatePicker1.SelectedDate, DateValue(TextPMeterDate.Text), Months) > -12, LightGreen, LightPink) Love this forum! Thanks again.
| User | Count |
|---|---|
| 132 | |
| 108 | |
| 65 | |
| 43 | |
| 39 |