The best thing I've come up with is to take out the value 0 from the dropdown list values, then the field will remain blank if zero. It looks like in order to get it to work properly, I would need to convert all the fields to character value, then I could have both a blank and a zero value as the numeric field doesn't appear able to do this...
>>I have a dropdown combo that is bound to a numeric field. The rowsourcetype is a value list with numeric values (one of which is 0). I would like the dropdown to be blank unless the value is non-zero or when the control receives the focus. This is the exact behavior I thought the format property of the field would do if it was type "Z". However, it shows the zero no matter what. What can I do to show the correct format? I have about 80 of these fields, so managing a character fieldtype would be tedious at best...
>>
>>Thanks in advance
>
>What is the controlsource property of the combobox and BoundTo property?
Steve Howie, owner
DaSH Technology
Denver, CO