define field length +++

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I never used access and am creating a query from a table. There are dollar
fields, some are displayed as 5.00, 15.00, 150.00...
I want to make the field fixed witdh, no floating decimals so it would look
like
00500, 01500, 15000 I would even take 005.00, 015.00, 150.00

Is this possible?

Thanks so much
 
If you want whole numbers, just set the Format property of the text box to:
00000

For the fractional values, use:
000.00

You problably should specify a negative format also.
 
Thanks that works, except now I want to export it to a file. When I try to
export it, it still sees it as $35.00 instead of the 035.00 that I have it at
now. Any ideas?

Thanks again
 
If this is for export, type a Format() expression into the Field row of the
query, and then export the query.

If the field is called F1, you would type:
Format([F1], "000.00")
 
Back
Top