>>>>I have a grid on my form with a column for listing a value if the record has a specific flag set. If the flag is not set a zero is placed into the column. This is based on a number field. How can I display an empty cell value when the value is zero?
>>>
>>>You can use Format=Z
>>>Or something like transform(yourvalue,'@z 9999.99')
>>
>>Hi Tore,
>>
>>Sometimes we are just too friendly. <s>
>>I let him look at InputMask and Format, rather than spell it out entirely.
>
>I was in a good mood, so why not share it? :-)
LOL
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.