by mike1174@[EMAIL PROTECTED]
May 9, 2008 at 08:18 AM
On May 9, 10:09=A0am, leejin...@[EMAIL PROTECTED]
wrote:
> Hi All,
>
You need to pad the number with spaces or 0's.
Format([field],' 00000')
> I have a quick question about Access. I know in Access you can ex****t
> the database into txt file (and choose which fields go to which
> space). However, the numbers in the txt file are all "align left".
> Would you please tell me how to do it in "align right"? Many Thanks!
>
> e.g.
> The txt file is like this:
> A____1___34567.10___222.10
> A____2___123.10_____45677.10
>
> This is what I want:
> A____1____34567.10_____222.10
> A____2______123.10___45677.10
