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.