It worked
Thanks for responding back I am new at this access biz, I am still working on getting the module to work. It works in the immediate window, but I havent been able to apply it to the field yet. In the mean time using the 0000 in the format propeties sections works great.