Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formatting negative numbers
Message
From
17/07/2006 18:40:13
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
17/07/2006 14:41:18
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01137018
Message ID:
01137088
Views:
20
>Dear Sirs:
>
>I want to format negative numbers enclosing in parentheses in an accounting package. I print the numbers with the following instruction (supossing value = -120):
>
>transform(value, "@(R 999,999,999.99")
>
>the output will be:
>
>( 120.00)
>
>But i don't know how to display this in a textbox or in a grid using FORMAT and INPUTMASK properties.

Generally, anything that was between the @ and the space in the picture string goes into the Format property (without the @ sign), and the rest goes into the inputmask. Unfortunately, the parenthesis is not on the list of recognized characters for the format property. So... not in a textbox. You may play with formatting the value as text when the focus is not in the textbox, and replacing it with a real number when it is. Make it half-bound, in a way.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform