Control displays null value as zero (0)

  • Thread starter Thread starter Mike Collard
  • Start date Start date
M

Mike Collard

I have a control populated by a procedure that can produce
a null value. Under this circumstance I want the control
to be blank but it displays a zero.

How can I force the control to display nothing if the
value is null?

Mike Collard
 
-----Original Message-----
I have a control populated by a procedure that can produce
a null value. Under this circumstance I want the control
to be blank but it displays a zero.

How can I force the control to display nothing if the
value is null?
Click to expand...

Do you have tested the nz() function?
select nz([fieldname],"") from table

Good luck.
Niels
 
Mike Collard said:
I have a control populated by a procedure that can produce
a null value. Under this circumstance I want the control
to be blank but it displays a zero.

How can I force the control to display nothing if the
value is null?

Mike Collard
Click to expand...

Displaying nothing for Null is the normal way for a control to behave.
Is it possible that the control has its Format property set to display 0
for Null? Post the control's Format property (from the control's
property sheet) if you aren't sure what it's doing.
 
The controls format property is blank so I would assume a
null is displayed as null.

Have tried the Nz(,"") but no luck.

The control is a combo with two columns bound to column 1
and I want the value of column 1 displayed when a
selection is made. If the column width of column 1 is set
to greater than zero then 0 is displayed if no selection
has been made but if the column width of column 1 is set
to zero then null is displayed with no selection. This is
a partial solution but it means that when a selection is
made the value of column 2 is displayed.

Hope you can follow this.

Mike Collard
 
Mike Collard said:
The controls format property is blank so I would assume a
null is displayed as null.

Have tried the Nz(,"") but no luck.

The control is a combo with two columns bound to column 1
and I want the value of column 1 displayed when a
selection is made. If the column width of column 1 is set
to greater than zero then 0 is displayed if no selection
has been made but if the column width of column 1 is set
to zero then null is displayed with no selection. This is
a partial solution but it means that when a selection is
made the value of column 2 is displayed.

Hope you can follow this.

Mike Collard
Click to expand...

Is it possible that you're seeing the default value of the field to
which the combo box is bound? Look in the table design of the form's
recordsource table, and check the Default Value of the field to which
the combo is bound. Maybe that is 0.
 
Back
Top