I have a datagridview bound to one SQL data table. Within that datagridview, I have one cell, Hotel, which is set up as a combo box which has a hotel table as it's datasource. The properties are shown below. My problem: When the user goes to the hotel combobox in the datagrid, if they begin to type in a hotel, even though the autocomplete property is set to false, the combobox does just that. Which will not allow my user to enter a new hotel name - one not in the list that they would then want to add. Any ideas on how I can get the combo box to only suggest hotels (like you could in a normal combo box) or even to not even do that, so that a user could potentially type in a new hotel?
Properties for Hotel column in bound datagridview:
Autocomplete: False
ReadOnly: False
DataPropertyName: Hotel
Datasource: HotelsBindingSource
DisplayMember: HotelScreenName
ValueMember: HotelID
ColumnType: DataGridViewComboBoxColumn