Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank when zero
Message
From
29/01/2009 13:08:01
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01377989
Message ID:
01378194
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

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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform