Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Probably easy list box question
Message
 
To
28/12/1998 09:50:07
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00170748
Message ID:
00170765
Views:
14
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform