Display format with number

rbuser

How can I sent the Display format so that I can get this result:

1) $23.45
2) $1.5657
3) $123,456.345
4) $12.40

I tried this $#,0.00##;($#,0.00##) but it doesn't seem to work... any ideas
on what I am missing?
Thank you, Mike M

digitalmetaphors

Our formats are totally replaceable. Check out this demo:
http://www.digital-metaphors.com/tips/ReplaceDisplayFormats.zip

Although, I'm not familiar with the format #3 that you mentioned.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

The problem is I want to show 3 or more places to the right of a decimal
but if after two places to the right is a zero I don't want it to show any
more places.
In your demo you have the same problem if you add the "#" sign as the
last digit to the right of the decimal it works fine but as soon as you set
the display type to a currency like $#,0.00#;($#,0.00#) no matter what even
if all zeros I get 3 places to the right. thanks MIKE

digitalmetaphors

Can you perform a customization to assign the display format if the value is
3 zero's? Use the OnPrint event of the dbText to set the display format to
$#,0.00#;($#,0.00#) when it is not three zeros, and $#,0.00;($#,0.00) when
it ends in .000.


Cheers,

Jim Bennett
Digital Metaphors