converting text into numeric

[ksraju6]

Hi !

Thanks in advance.

I have a text field in my access table, which is to be converted into number before sending it to another table . this field has leading zeros in the front eg:000074. But when i convert it into number it is becoming 74 .

How can I Control that ? I want it to be shown as number 000074 .

Is there a way to get it converted to number 000074 ???

PL. help me out !

hirshfielda@aetna.com

 

[tunsarod]

As far as I am aware you cannot store a numeric with leading zeros. What you can do is to display it with leading zeros by setting the field's Format property.

Type 000000 into the Format property for the display field and you should get the result you're looking for.

Rod