Filtering out a based on a filled field

[chellebell1689]

Hello, I have a form that I want to filter out certain records based on if a field has data in it or not. I tried using a macro and putting the field equals "IsNotNull", but that didn't work. I just asked me what "IsNotNull" is suppose to be.

Can anyone tell me the correct way to do this via macro please?

I tried searching but was finding VBA with other filters being applied (which is not the case).

Thanks.

 

[vbaInet]

[Field] Is Not Null

Or

Not [Field] Is Null

... either one.

 

[chellebell1689]

That works perfectly! Thank you!

 

[vbaInet]

You're welcome!

As an aside, if your field ever contains the empty string, i.e. "", the Is Null operator won't filter it out. So to avoid this problem, set the field's Allow Zero Length String property to No in the table.