Hello,
I am trying to store track numbers in a Long Integer field. I'm getting the track number from a string and converting it to a long to write to the db. If the track string has no number, I want to leave it blank but Access is requiring me to put a number there or I get a Type Mismatch error. So I started throwing a '0' in for blank track numbers. Is there a way that I can leave it blank without having to put a zero in the db?
Thanks,
Rick