Validation textfield Respondida

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 ? 

Comentarios

1 comentario

Fecha Votos
  • Comment author
    Nadav Caridi
    • Comentario oficial

    Hi 

    You can use dynamic syntax with SQL 

    SELECT ISNUMERIC(yourDyanmicSyntaxFieldHere);

Iniciar sesión para dejar un comentario.