>I am using a click in a listbox to set the recordsource of a grid control. One of the columns lists a note number. Not all the records have an associated note number. The ones that don't displays a zero. How can I make the text box in the column display as empty for these records.

If that column should not be editable, you can put an expression in it's ControlSource, like:

IIF(order_items.quantity = 0, "", order_items.quantity)