Guess I'll go that route since it'll get us the proportional font with
only a tiny bit more work for me. Thanks HK.
Regards,
Andrew Baker
Project Administration & Resource Planning
Gillette GBU, Blades & Razors
Proctor & Gamble
Tel (617) 463-3024
Fax (617) 463-3783
e-mail: [EMAIL PROTECTED]
"Hal Kaplan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/29/2007 12:26 PM
Please respond to profox
To: [EMAIL PROTECTED]
cc:
Subject: RE: VFP 6: Formatting a negative value in a report
Actually, there is another way but I could not remember it when I wrote my
original response.
Putting the leading (left) paren in place is fairly straightforward. The
trick is to leave room for the right paren even when you don't need one
(i.e. a positive number). The way to get around this is to make the right
paren a separate field that contains either a right paren or nothing.
Thus you have two fields, one for the number:
iif(v<0,"(","")+ltrim(trans(abs(v),"#,###.##))
and a second field immediately to the right of the first:
iif(v<0,")","")
Now you don't care what the font metrics are as long as your field sizes
are large enough to hold the displayed data.
B+
HALinNY
[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
** 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.
