Access 2007: Got rid of drop-box control (i.e. combo w/key entry restricted)?

[GlistEngineering]

Did they get rid of the drop box control?

I have a form with a combo box that is sourcing values from a table. I have "restricted to list" property set on, but users can still enter blanks. This is no good. I need a drop box that does not allow users to type in the box.

Seems simple. Why can't I find it?

[pbaldy]

The Limit to List property should restrict them to selections on the list, whether they type or select. If you want to make sure they enter something (not leave it blank), you could make the field required in the table.

[GlistEngineering]

Actually, that is not an option because the combo box is unbound.

[pbaldy]

Are the users "entering" a blank or simply leaving it blank? I'm not sure what you're doing with the combo, but you may want to test for the blanks before doing whatever you're doing.

[GlistEngineering]

Leaving it blank is not an issue because it won't try to pull-up a record until the user enters something. I am trying to limit users from entering a blank to keep my database air-tight.

I decided to just go with a list box, but am disappointed a drop-box control does not seem to be available in Access 2007.

Are the users "entering" a blank or simply leaving it blank? I'm not sure what you're doing with the combo, but you may want to test for the blanks before doing whatever you're doing.

[TG_W]

What about a validation rule or some other coding that stops the code and pops up a message box if the combo box is left blank?

[Missinglinq]

...I decided to just go with a list box, but am disappointed a drop-box control does not seem to be available in Access 2007.

The Combobox certainly is available in v2007! I'm not exactly sure how you enter 'blanks,' but if your quest is for "a drop box that does not allow users to type in the box," as you posted, you can use the KeyDown event of the Control:

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
 Select Case KeyCode
  Case vbKeyReturn, vbKeyTab, vbKeyUp, vbKeyDown
   KeyCode = KeyCode  'Accept these keys
  Case Else
   KeyCode = 0 ‘Block all other keys
 End Select
End Sub

Linq ;0)>