Dear Tom,
Thanks! I will try.
Err... after testing, we find our user's Access 2007 program behaviour differently in the Access 2010 Runtime. An optional date field always get default value at the time we click on the "export to excel" button. We can't correct the issue due to
budget consideration. I will downgrade my Access version form 2010 to 2007.