how use "format" to print leading zero as space?

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

Guest

Thanks for any help.
I have a query that I select all, copy, and then paste to Wordpad or NotePad
to make a text file.
It's basically about a 1000 rows of some letters at the beginning, and then
about six numbers after that.
The numbers vary in magnitude depending on row, so that some are in their
tens, and some are in their tens of thousands.
It's hard for me to read the rows easily, even in Courier font, because it's
like this:
ULEM 198407 1300.000 12 81.253 108.333 975.037 975.037
ULEM 198407 494.346 5 9.339 98.869 46.694 46.694
So I thought I could do like this:
ULEM 198407 1300.000 12 81.253 108.333 975.037 975.037
ULEM 198407 0494.346 05 09.339 098.869 046.694 046.694
And I can do that using format(sdfdsf,"0000.000") etc.
But I thought, can I do like this:
ULEM 198407 1300.000 12 81.253 108.333 975.037 975.037
ULEM 198407 494.346 5 9.339 98.869 46.694 46.694
Where the decimal points line up over rows. I don't know how to do this with
format ("#" doesn't work).
Anyone have any ideas?
Any help much appreciated!
Thanks.
 
Hello Ian.

Ian said:
Thanks for any help.
I have a query that I select all, copy, and then paste to Wordpad
or NotePad to make a text file.
It's basically about a 1000 rows of some letters at the beginning,
and then about six numbers after that.
The numbers vary in magnitude depending on row, so that some are
in their tens, and some are in their tens of thousands.
It's hard for me to read the rows easily, even in Courier font,
because it's like this:
ULEM 198407 1300.000 12 81.253 108.333 975.037 975.037
ULEM 198407 494.346 5 9.339 98.869 46.694 46.694
So I thought I could do like this:
ULEM 198407 1300.000 12 81.253 108.333 975.037 975.037
ULEM 198407 0494.346 05 09.339 098.869 046.694 046.694
And I can do that using format(sdfdsf,"0000.000") etc.
But I thought, can I do like this:
ULEM 198407 1300.000 12 81.253 108.333 975.037 975.037
ULEM 198407 494.346 5 9.339 98.869 46.694 46.694
Where the decimal points line up over rows. I don't know how to
do this with format ("#" doesn't work).
Anyone have any ideas?
Any help much appreciated!
Thanks.
Click to expand...

I would suggest something like this (for thousands):
String(Len("0000.000")-Len(sdfsdf)," ") & format(sdfdsf,"0.000")
 
Sorry, I forgot the decimal places:

String(Len("0000.000")-Len(format(sdfdsf,"0.000"))," ") &
format(sdfdsf,"0.000")
 
Right(Space(9) & Yourfield,9)

Replace "9" with whatever number of characters you want in the result.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thanks John!

John Spencer said:
Right(Space(9) & Yourfield,9)

Replace "9" with whatever number of characters you want in the result.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Back
Top