Blank Field in lookup

  • Thread starter Thread starter Mary Hartman
  • Start date Start date
M

Mary Hartman

I have created a form with a number drop down lookup fields in the
table.

The problem I am having is that if someone makes a mistake and selects
an item from a drop down in a field that should be left blank, they
can't change it back to a blank.

How can I add a blank selection to these drop down lookup controls in
the form?

Thank you
 
Does is have to be blank? Can you use a symbol like "-" or even "N/A"
instead? Otherwise, add a blank option to your drop down menu by entering "
" as one of the options.

B
 
Does is have to be blank? Can you use a symbol like "-" or even "N/A"
instead? Otherwise, add a blank option to your drop down menu by entering "
" as one of the options.

B
 
Back
Top