>I have created a temporary table which I use in a grid control. The table contains character, numeric and currency field. When I create the table I insert 150 empty records. Now in the grid control the character field looks fine (empty) but not the numeric and currency field (they have 0.00 written it them). How do I do to not show anything in them when the table field is empty?
>
>And why is the numeric field empty when it gets focus but not the currency field?
>
>/Mårten Törnquist
Put a "Z" in the Format property of these textboxes - it means "blank when zero". Though, it won't be nice if you really have a new value which accidentally is zero - it will look blank. If this is not what you need, go for the .null. solution.