Formating a text box

[Razzie33]

Hi!

I have a report based on queries and i need it to look a certain way for a flat file. I need to get a fixed currency amount to be defaulted to 17 characters with the missing characters being zeros.

ex: 5913.00
must look like: 00000000005913.00

i dont know weather to use an imput mask or format
thanks

 

[jebry]

Hi!

In your query you will want this field:

NewFieldName: Format(YourField, "00000000000000.00&quot

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Razzie33]

thank you very much for your help

that did the trick!!!