MS Access – MySQL Zero-Length String Problem

I use MS Access to connect to my MySQL database, using MyODBC. Here is a “simple” problem that give me quite a headache. I create a table on MySQL database with VARCHAR field, NOT NULL I link my table on my MySQL to MS Access. I create a form based on that table. Somehow, MS [...]