Converting Numerical field to a Text field.

[honeyrun]

I have a numerical field (with a decimal) that I need to convert to a text field (without decimal). I can get the decimal to go away by using "Replace([Amount],".","&quot, but ending zeros are not showing. I also need leading zeros to fill the field to 10 characters. Any help would be appreciated.

Thanks,

 

[Norris68]

Try... Format([NumericField],"0000000000&quot

 

[scriverb]

Try this expression:

Format(Mid$(Cstr([Amount]),1,Instr(1,Cstr([Amount]),".&quot-1),"0000000000&quot

Post back with questions

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[honeyrun]

Bob,

That partially worked, but the 2 numbers after the decimal didn't convert, they were left off. Is there a way to convert them also, including if the ending number is a zero?

Thanks

 

[honeyrun]

Norris68,

That converted the number to text, but rounded the two decimal places up to a whole number. I still need the two decimal places to convert to text also without the decimal point.

Thanks,

 

[Norris68]

How about... Format([NumericField]*100,"0000000000&quot

or if you want to keep the decimal places... Format([NumericField],"00000000.00&quot

 

[honeyrun]

Norris68,

That was it, Thank you very much

 

[scriverb]

honeyrun: As you can see you didn't ask for a rounding expression. You just wanted the decimals to go away. Norris68 has given you a good expression to that and is better than mine. Less complex is better.



Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???