If Else commands based on Empty fields

  • Thread starter Thread starter Sok Hong
  • Start date Start date
S

Sok Hong

I just added a command button. For this command button, I
want it to check if Field1 is blank, and if so I want it
to do nothing. If Field1 has something filled in, I want
it to go to add a new record. Any clue how I can go about
programming this? Thanks.
 
Sok Hong said:
I just added a command button. For this command button, I
want it to check if Field1 is blank, and if so I want it
to do nothing. If Field1 has something filled in, I want
it to go to add a new record. Any clue how I can go about
programming this? Thanks.
Click to expand...
Using the NZ function to check the field will check for both Null and empty
strings.
If you just want to see if it is Null you can use isNull.
 
Back
Top