Asp insert into access using double deletes beginning zeros

[jamestflynn]

Hello,

I'm trying to input data into an access database using asp and I'm using double as the number field type in access. And whenever the number is inserted it is around 9 digits sometimes the number begins with 2 zeros but when inserted the beginning zeros are deleted.

How can I have the number inserted and keep the initial zeros?

Thanks,
James

[bbolte]

you can't with a double data type. you'll have to change the type to text...

[jamestflynn]

Will any of the other number fields retain the beginning zeros?

Thanks for your help,
James

[bbolte]

nope, since real numbers don't begin in zero. do you really need it as a double?

[jamestflynn]

No it doesn't really have to be a double I suppose. The only requirement was that it be 9 digits long that's why I made it a double.

Thanks,
James

[jamestflynn]

I talked to the client and text was acceptable so I just changing that particular field to a text field.

Thanks for your help,
James

[bbolte]

you can check the length of a string and make sure that is 9 characters long:

if len(mystring)>9 then
    ' do something about
end if

i'm assuming that this is coming from a form or something. you can also do some JavaScript validation to make sure that the input is the correct length. And, if this is indeed coming from a form, set the max size of the form field to 9.

[jamestflynn]

Thanks for your help. Yes the data is being collected from a form and a javascript validation would probably be best.