Allow only numbers with a fixed number of characters
Posted on 2011-03-11
I have an Access 2007 table with 5 columns that I only want to allow numbers with a fixed character length of 3, therefore I have set the data type to number and the field size to byte with a mask of 000 which works except it drops the leading zero, I know I can change the data type to Text but that will allow numbers and letters I only want numbers. I have tried setting the field size to integer with the same results. Any incite on this would be greatly appreciated.