Convert to a string, search out a decimal point and pad the string out with spaces and bobs your uncle. You will need to make the font fixed width to achieve this.
Alternatively convert to a string, make two strings, one of before the decimal spot, one including and after the spot; then right align the units and left align the decimal then you can use whatever font you like. Cheers Adam. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: 29 November 2007 14:51 To: [email protected] Subject: RE: Decimal-aligning data in reports Thanks much, Andrew. I considered that, but would prefer to not show trailing zeros where they're not necessary. For example, in Quantity. We wanna see "123" - not "123.0000." Doable any other way? > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:profoxtech- > [EMAIL PROTECTED] On Behalf Of Andrew Stirling > Sent: Thursday, November 29, 2007 9:46 AM > To: [EMAIL PROTECTED] > Subject: Re: Decimal-aligning data in reports > > John > > Format the numbers to have the required decimal places ie if your unit > price was 0.052 it would display 0.0520. Make each of the fonts non > proportional. > Then you can place the text boxes the way you want. > > HTH > > Andrew Stirling > 01250 874580 > http://www.calcpay.co.uk > HMRC Accredited UK payroll program > > > John J. Mihaljevic wrote: > > Hi all, > > > > I have the following three fields listed one underneath the other in > a > > column: > > > > Quantity > > UnitPrice > > ExtendedPrice > > > > Examples of those values may be: > > > > 100 > > 0.0525 > > 5.25 > > > > We don't want the numbers left-aligned or right-aligned...we want > them to be > > aligned by the decimal. Is there a way to automatically choose data > in a > > report form and have it align by the decimal point, or do I have to > move > > each field manually until they're properly aligned? > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
