I'm currently encountering a problem. I have set up an if statement on a text box - if the number is smaller than 2.4, and larger than 6 then return an error.
However, if a user wishes to input 2.8, it will throw the error when 2 is entered, and when the '.' is entered.
Here is my code:
Please Login or Register to view this content.
Put your code in the LostFocus event, rather than the Change event.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly, but now it isn't updating at all in my "Total" text box
It will when the txtHeight text box loses focus... Tab / click to next control.
I have changed it to AutoRefresh instead of Change. It now works - thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks