Set up a default in Combo Box to show when opening a form

  • Thread starter Thread starter JuliaO
  • Start date Start date
J

JuliaO

I have a combo box which uses a table with No and Yes. I want the No to be
the default whenever I open the form. I have tried several default values
suggested in microsoft but none have worked.
 
Yes/No fields in Access are designated -1 for Yes and ) for No. So your combo
format needs to be set to number and then in your control source put
=IIF([yourfieldname]=-1,"Yes","No")
 
Julia

A common way to handle Yes/No is with a checkbox, rather than a combobox.
Is there a reason your application needs to use a combobox?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top