Validation textfield

Respondida

Alain Seys

• 9 de febrero de 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

• Comentario oficial

  

  Nadav Caridi

  • 9 de febrero de 2021 23:33

  Hi 

  You can use dynamic syntax with SQL 

  SELECT ISNUMERIC(yourDyanmicSyntaxFieldHere);

Iniciar sesión para dejar un comentario.