John, Slight error - replace all the "x"'s with cPad_Char!!!!! Dave Crozier
-----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.

