Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank when zero
Message
From
29/01/2009 06:08:41
 
 
To
29/01/2009 00:39:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01377989
Message ID:
01378022
Views:
17
>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform