Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Blank when zero
Message
De
29/01/2009 13:08:01
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
29/01/2009 06:08:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01377989
Message ID:
01378194
Vues:
16
>>not a good day for me, I should know this.......But it's late and I'm tired and this is the only time-of-day I have available to donate my programming skills (such as they are) to the synagogue so...............
>>
>>Given a textbox with a numeric value.......what property do I set to what value so that the textbox will display BLANK when zero?
>>
>>Thanks...........Rich
>
>You could try the "print when" checkbox in the field's properties, type:
>
>IIF( ThisField > 0, ALLTRIM( STR( ThisField), "") && or some TRANSFORM() ion the field to get your formatting

For those who missed this detail: you can actually combine the function codes in your transform()s. You only need to put them in front of the format string, preceded with an at sign and followed with a space. So, in this case

transform(thisfField, "@Z 999,999,999")

will return eleven spaces when thisfField is zero.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform