Access Database Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database with a form. One of the combo boxs has a drop down selection list on the box on input form. When the form is displayed for data input a "value" of -1 is displayed in the box instead of text. The drop down menu can be accessed, one of the acceptable texts can be selected and it "takes". How do I eliminate the -1 value that is displayed on the input screen prior to data input?
 
Do you have a Default Value set for that combo box? What is the Row Source
of the combo box? What is the Colum Count property set to? What is the
Column Widths property set to? What is the bound column number?

--
Ken Snell
<MS ACCESS MVP>

harryt said:
I have an Access database with a form. One of the combo boxs has a drop
Click to expand...
down selection list on the box on input form. When the form is displayed for
data input a "value" of -1 is displayed in the box instead of text. The drop
down menu can be accessed, one of the acceptable texts can be selected and
it "takes". How do I eliminate the -1 value that is displayed on the input
screen prior to data input?
 
Reply:
Do you have a Default Value set for that combo box? = blank
What is the Row Source of the combo box? = value list
What is the Column Count property set to? = 1
What is the Column Widths property set to? = blank
What is the bound column number? = 1
 
OK - is the combo box bound to a field in the form's recordsource? Does that
field have a default value in the table's design view?
 
Ken,

The answers to your last questions are “yesâ€. I went in deleted the table’s default values that were bound and it resolved the problem. Thanks for the help. I had worked all angles I knew and still had the problem. Usually I can work through these things, but this one stumped me. Thanks again. HT


----- Ken Snell wrote: -----

OK - is the combo box bound to a field in the form's recordsource? Does that
field have a default value in the table's design view?
 
Back
Top