Jeff Johnson wrote:
I have reports that print a number in a $$$,$$$.99 format. If I size
the field too small it will display ********** instead. It seems it
does that even if the number is $7.25. When using fields without the
$'s it seems to print fine until the number is actually too big to fit.
Is there any kind of a rule regarding this? Does the above format
make sure the field is big enough for the largest number?
TIA
The field must be as wide as the format. Your format of $$$,$$$.99
needs to be 10 wide. If you don't think you will get 10,000 or over
you could put in $,$$$.99 as the format, then you only need 8 wide but
you still get the thousand comma separator.
Peter
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.
