Open database using Access
Open the table in design mode
select the field that you want to modify
make sure that allow zero length is set to yes