Printable View
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
Go into Access open the said table and go to the long integer field on the properties opf that field make "required" = no and Allow Zero Length = yes.
good luck.
b :)
Hi Beacon,
I'm using Access 2002, and I can't seem to find the 'Allow Zero Length' property. I have the 'required' set to 'no' already. Any ideas what I'm doing wrong?
-Rick
Sorry allow 0 length isnt avail for numbers.
Remove the default value in the properties.
It will be 0 as default.
It's still forcing me to add a number to the field. I keep getting the type mismatch unless I throw a zero in there.:confused:
Beacon,
Thanks for the help. I've decided to just take advantage of the NULL values. :)
to answer your initial question:
NO
There is no way to leave a numeric field empty when saving it. This would break the convention of the numeric fields. A numeric field HAVE TO BE FILLED with data after a new record got created. Whatever the filling is .....
Franky