>>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.