Information générale
Titre:
Null display in comboboxes
What is the most efficient way to make a combobox display a string such as "TBD" or "N/A" when the value is Null? I may have a lot of these controls on the form, so I'm looking for the most efficient way, in Access 97 and 2002.
I'm using a lookup table for the combos, with one field for the stored value and one for the display value. It works, unless the stored value is null, in which case it shows a blank, rather than the value I have in the "display value" column of my lookup table.
Thanks in advance.
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement