Hi Craig!
Yes I realize that you can let Access decide but, IMO, is never a good idea. Again, IMO, it is always best to give the program explicit instructions on any data type and any conversions you want Access to do. I thought that this could be a case where explicit instructions might help. It is something else to try anyway.
hth
Jeff Bridgham
bridgham@purdue.edu