Validation rule or required fields with VB

[dejanc]

Hello all,

I need help. I have create very cool database for Company X. I have found one mistake about validation rule in Field Properties.

I have create a few field, which some of them have validation rule Is Not Null, and they must not be empty. After enter information in the fields, they are exported into excel. In the end of export job, I have query which clear some fields. Here comes a problem.
When customer want to fill again choosen record, the validation rule does not working any more, and it does not warning that must not be empty.

I would like to create validation rule with Visual basic. I have just started exploring VB, so I will need help about it.

Thanks for help in advance...!

 

[vbaInet]

Use the Len() function instead. Investigate that.

 

[dejanc]

thanks, I will