ms access 2000 table default value truncating leading zeroes
Posted on 2015-01-23
I need to setup a table in ms access 2000 that will be used to send data to a text file. Some of the fields(columns) need to have default values like '01' . but when I put 01 in the default value for a field, it display just 1. it needs to display 01( is truncating the leading zeroes.) I need to export this table to a text file with the value not truncated( i.e. 01). I tried with single quote and I get error. I also tried formats like 999999 or 000000, but did work either.