3 closely related questions:
1. If I'm using Access 2000 & ASP, is it better to test for empty text & memo fields using:
A. the IsNull function, e.g., If IsNull(rs("fieldname")), or
B. check for the field being equal to an empty string, e.g. , If rs("fieldname") = "" ?
2. By default Acces sets all fields AllowZeroLength strings to False. Would I have to change the field's AllowZeroLength property from False to True to be able to check for an empty text fields?
3. If I want my ASP pages to be as portable as possible (easy to use if I ported the database from Access to another database like MySQL), what would be the best solution for testing for empty text or memo fields?