Thanks for clarifying this for me. I have adjusted the VBA code so although the field shows #Error? in MS Access it will export the correct blank date in the mysql dump file.

Cheers

Jim