I am trying to use the IsMatch to verify a TextInput of Time. Currently it is
IsMatch( TextInput1_1.Text, OptionalDigits & Digit & ":" & Digit & Digit)
. This is so the user can type in 5:00 and it would work. The problem is that the user can also type in 125:00 or 213455135:00.
Is there a way to just allow a single optional digit?
Go to Solution.
Could you combine this with the LEFT or RIGHT function and only return a single value to the left of the : sign?
edit: I ment left/right, sorry
View solution in original post
Thanks, that worked. I then discovered though I could just set the maxlength of the text input to 5 so the user can't even type in more than that.
That is what I wanted to suggest.
@Alerts_OM_USA wrote:Thanks, that worked. I then discovered though I could just set the maxlength of the text input to 5 so the user can't even type in more than that.
I didn't know you could do that, great find!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.