Show a default text for NULL values with DropDown lists

[Vince C.]

Hi.

I'd like a drop down list to show a default value when the bound field
(which type is Integer) is Null. Currently the list shows an empty text
when the bound field is Null. I've tried using the "Format" property but I
was all my attempts resulted in displaying no text at all.

I must use a function to populate the list.

Thanks for any hint/suggestion.

Vince C.

 

[JethroUK©]

if it's a number field you can simply change the table design to default to
any value you like (prolly 0)

 

[Vince C.]

if it's a number field you can simply change the table design to default
to any value you like (prolly 0)

Thanks, JethroUK.

But suppose I cannot change the column definition to NON NULLable?

Vince C.

 

[JethroUK©]

Thanks, JethroUK.

But suppose I cannot change the column definition to NON NULLable?

Vince C.

i think you need to describe how your combo is setup

does it display the column/field it is bound to? (which of course are not
the same) or is it being used to display lookup to another table/list/value