Accept input in textbox if it's divisible by 100, else notify the user and clear the input field. And also change format to "#,###.00" once the input is successfully divisible by 100.
What do you mean it's divisible by 100, every single number in world is divisible by 100. If you want to check if input number is divisible by 100 without any rest (mod), then solution is below. But then why such format .00?
With txtInput
Format=TextFormat.Number
OnChange=
Set(varMyValue,Mod(Self.Text,100));
If(
varMyValue = 0,
// if statement is true
Set(varMyOutputValue,Text(Value(txtInput.Text),"##,###.00")),
// if statement is false
Notify("Wrong number",NotificationType.Error);Reset(Self))
Share
Report
All responses (
Answers (
138
