>>I've got a listbox that has several columns in it. The source is a SQL statement. The second column is created by the sql segment "transform(total, "$$$,$$$.99")" (just in case that's important). I need to line up the decimal points but don't know how. How can I get these numbers to line up? Thanks!
>
>Denise,
>
>The suggestions about the font are ok, but numbers all have the same width regardless of font. You need to left pad the numbers to be of equal length as in;
>
> PADL(TRANSFORM(Total,"$$$,$$$.99"),10)
This is true, but numbers and spaces are NOT necessarily the same size. So ssss123.45 is not the same size as sss9876.54. I guess you could play around with TXTWIDTH until you got a match...