Validation textfield

Answered

Alain Seys

• February 09, 2021 21:27

Hy can someone help me with a validatio of a field  ?

i want to check when the users leaves a text field that the entered value is check if it is numeric or not. When not it should return a messagebox.

whith sql and macro the data gets behind if , the data should be checked before it gets entered in the database 

 

any tips ? 

Vote

0

• Official comment

  

  Nadav Caridi

  • February 09, 2021 23:33

  Hi 

  You can use dynamic syntax with SQL 

  SELECT ISNUMERIC(yourDyanmicSyntaxFieldHere);

Please sign in to leave a comment.