Empty fields

[rickyfong]

In my table, I got text fields and numeric fields, however, sometimes, user put an empty field in some records which I disliked. I try to put some checking such as following syntax to check those empty field but nothing happened. Am I missing something?? Any idea?? Thanks!

1) If len(NAME) = 0 THEN error message : for TEXT field checking
2) IF len(name) = NULL then error MESSAGE : for TEXT field CHECKING
3) IF NAME = "" then error message : for text field checking
4) IF LEN(AMT) = 0 THEN error message : FOR NUMERIC field checking
5) IF LEN(AMT) = NULL then ERROR MESSAGE : for numeric field checking
6) IF AMT = "" THEN error message : for numeric field checking
7) IF AMT = NULL then ERROR message : for numeric field checking

 

[rickyfong]

IT seems ISNULL(NAME) and ISNULL(AMT) worked well!!