So I take it if you want a proportional font with negative values wrapped
in parens you need a font where the width of the non-breaking space and
the right paren match. Anyone know of one or is there a function that
returns the width of a character in a specified font. Seems there's one
for avg width and one for max width.
Regards,
Andrew Baker
e-mail: [EMAIL PROTECTED]
"Hal Kaplan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/29/2007 09:31 AM
Please respond to profox
To: [EMAIL PROTECTED]
cc:
Subject: RE: VFP 6: Formatting a negative value in a report
Put this expression in the report ...
iif(v<0,"(","")+ltrim(trans(abs(v),"#,###.##"))+iif(v<0,")",chr(160))
where v is the number you are formatting.
This field should be right-justified in the report or you can just put a
padl() around the expression.
If you do not use a monospace font, the widths of a right-paren and a
non-breaking space may not be equivalent.
B+
HALinNY
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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.
