Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Negative amounts in red with parens
Message
 
À
08/05/2007 17:20:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Divers
Thread ID:
01223619
Message ID:
01223700
Vues:
17
>I need a control that displays negative dollar amounts in red and with parenthesis instead of a minus sign. I will use it for data entry as well as inside grid controls - the latter for display only, not data entry.
>
>I've been able to use an assign method on the Value property to change the forecolor if the value is negative. (It got a little tricky with using the control in a grid, but I've gotten it to work.) What I'm having trouble with is removing the negative sign and using parenthesis instead. I haven't found any format code or input mask that will do this. Any ideas?

To display Fore color in red you can use DynamicForeColor property of the grid:
thisform.Grid1.ColumnXXX.DynamicForeColor = [IIF(GridRecordSource.ColumnWithAmmount < 0, RGB(255,0,0), RGB(0,0,0))
Now I'm thinking how to put [(] and [)] over the negative values.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform