Validation textfield Answered

Alain Seys

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 ? 

Comments

1 comment

Date Votes
  • Comment author
    Nadav Caridi
    • Official comment

    Hi 

    You can use dynamic syntax with SQL 

    SELECT ISNUMERIC(yourDyanmicSyntaxFieldHere);

Please sign in to leave a comment.