I am working on a macro that should check to see if a field is blank, then close that form without saving the rec, and open another form. The field is text. The if statement has the full reference of forms!form name! etc, but i typed if [field] <>" ", and i'm getting a data mismatch error message on that. The macro creator is rigid. In code I would say If isnull([field name]). but the macro doesnt accecpt that either. How can I code this. Thank you so much!
Access 2010
Access 2010