Problem with insert 1

[Watermelon]

Hi,

I'm trying to insert the value from a control on my form named Part into a QuoteLine table. For some reason when the first digit of the Part field is 0, the 0 will not be inserted into the table. The rest of the numbers will be inserted but for some reason the 0 is not going in. So, if I have number 036708 everything but the 0 is inserted. The datatype for this field in the table is text.

Does anyone know why this is happening?
This is my sql statement

sql = "INSERT INTO QuoteLine(Quote, Part)VALUES (1," & Part & &quot"
Thanks,
TM

 

[LarryDeLaruelle]

Melon:

My first guess is that the source is formatted as text and the target is formatted as number.

Number fields will not hold preceeding zeros unless specifically formatted for such in table design.


Larry De Laruelle
larry1de@yahoo.com