Remove dropdown arrow from read-only combo box

Is it possible to get rid of the dropdown arrow in a combo box and make it look like a text field?
I want to make the form to act different at MouseDown event in a combo box depending on whether the dropdown is currently down or not. Is there any way to do it? I could not the property of a dropdown list state for a combo box.

Sponsored Links:

Related Topics

Is dropdown list of combo box down?
I want to make the form to act different at MouseDown event in a combo box depending on whether the dropdown is currently down or not. Is there any way to do it? I could not the property of a dropdown list state for a combo box.


Combo Box drop down arrow invisible on reports
I'm a little rusty and maybe I'm missing something here, but. when I create a Combo Box on a report, the drop down arrow doesn't show in Report View. It shouldn't be like that, right?

I'll create a blank report, add a Combo Box and a RowSource. the drop down arrow is there in Design View, but once I switch to Report View, gone. I do still get auto-complete on the control as soon as I start typing.

And if I copy the same Combo Box to a form, it works just fine and the arrow shows.

Is there some reason why Combo Boxes shouldn't work on a report? I had never used them on reports before, but I can't think of one.

I'm using Access 2010 and Win 7.


SendKeys & Dropdown
I'd like to get a combo box to drop down automatically AFTER the user SAVES his first combo box selection.

That is, I don't want the dropdown to happen on the first selection.

In the coding for the SAVE button's "on click" even, I set the focus back on the combo box. Then, I was going to use SendKeys "{F4}" to force the combo box to drop down.

But that doesn't seem to be working.

I suppose I could use the Got_Focus event for the combo box, but then I believe the dropdown would happen on the first use of the combo box


Combo Box without the arrow?
I want my form to LOOK cool. Can I have a Combo Box without the arrow? Or at lease the features of a Combo Box with VBA code to perform the same actions?

I want the field to auto fill like a combo box and if needed to pull up a list. I could put code in OnUpdate for auto fill and OnClick for a list.


Combo Box: You can't assign a value to this object
I am trying to use a combo box within a subform. In form view, I can see the drop-down arrow and when I click on the arrow I can see the desired selections. However, after I make a selection I am getting the following error message:

You can't assign a value to this object.
*The object may be a control on a read-only form.
*The object may be on a form that is open in Design view.
*The value may be too large for this field.


Minimizing combo dropdown on click
I have a record selecting combo box as the first control on my main form with a dropdown event on Change to help narrow down the record of choice as text is entered into the combo box. Works great if you use the Enter keystroke to finish selecting the record. However, if you use a mouse click, the record is selected and form populated, but you have to click outside of the dropdown to get the dropdown to disappear.

I would like a mouse click on the selected record to also get the dropdown to disappear.

I have tried changing the dropdown event to On Dirty and Before Update, but then I don't even get the dropdown, which works fine on On Change.

Is there code for On Click to minimize the dropdown after selecting the record


Combo Box, selecting multiple items in dropdown
I am new to access and trying to build a database right now. I have created most of my necessary tables, and I am creating a form to populate information from these tables. Part of the form needs to be able to have a dropdown list for the user to access the data from select tables in the dropdown list.

I am currently using a combo box and then linking to the necessary table.

I need to be able to select multiple items in this dropdown list, but in my current dropdown, I can only select one item. Is there a way to allow multiple selections in thedropdown to be displayed in the form? Is a combo box the correct method for what I am trying to accomplish?


remove sorting
How to remove sorting in form with subform in datasheet view. I want to remove small up arrow or down arrow. With right click there is only sort A to Z and oposite but there is no remove sorting.This annoying me


How to skip selecting dropdowns null in last two fields of Synchronized Combo Boxes
I have a series of seven synchronized Combo boxes that work.
The last two combo boxes are VDwgNumber and VDwgRevision. About 85% of the time, there is no VDwgNumber and VDwgRevision and the drop down list has only one null value. (Also, if VDwgNumberis null, there is no VDwgRevision and it will be null as well.)

Currently, when I get to the VDwgNumber combo box and the VDwgRevision combo box, I have to choose the "null" value from the drop down even though the combo box itself is null. If I do notuse the dropdown nulls, it will not return a ValveID which is the control source for the last combo box.

I have both combo boxes set to dropdown on the got focus event but I have also tried without displaying the dropdown lists on got focus.

Why is the null in the combo box no recognized the same as the null from the drop down list? Is there a way to get Access to treat it as the same?


Drop Down Menu Auto Load on form?
Right when I type something, I want the dropdown menu to appear instead of clicking on the arrow

This is because I have 2 fields in the dropdown menu (Last Name, First Name)

I can only see the Last Name Auto Completed. I have to have to click on the arrow thing to see the First Name


Closing a combo box
This one is driving me up the wall. I have several combo boxes on my form, which are locked depending on the value entered in another field. When the user clicks on one of these combo boxes, a message pops up telling them they can't make any changes. So far so good. But if they've clicked on the down-arrow on the right of the combo box, once they've OK'd the message the full dropdown list is displayed. How on earth do I stop this happening or at least close the list again programmatically?

I have variants of this in my On Mouse Down events:

If Me!Status.Value = "Cancelled" Then
MsgBox "You cannot amend a record for a cancelled document." _
, vbInformation End If


Combobox AutoCompleteMode SuggestAppend
I am trying to find a way to know when the suggest dropdown list is showing and when it goes away.

So Say you have typed "cos" and the suggest append dropdown list shows "cost" when you type the letter T the dropdown list goes away at this point I would like to be able to change the index of the combo box instead of waiting till the combo box loses focus.

Is there an event or property that I can check to see if that list box is showing?


Combo Box dropdown to size width of columns
How do I make the dropdown of a combo box wider when I click on it? I forgot which property to set which will make it autosize the width


Display selected value of Combo Box
I have a combo box the elements of which are one field from a table in the database. Under Property Sheet for the combo box, I have Record Source set to blank and Recordset Type set to Dynaset. When I click on the arrow at the end of the combo box, I get the proper list of choices, but when I select one of them, the field of the combo box remains blank. Of course, I want the combo box to display the selection that I just clicked on, and then to code an action based on the selection. I have been examining all of the properties of the Property Sheet and have experimented with some, but still a blank in the combo box


Issue with combo box in form
I converted a small, very basic Access 2000 database to Access 2003. The database uses a form for Order details, which contains two combo boxes - 1 for principal name; 1 for customer name. After the conversion from 2000 to 2003, the dropdown list does not display the values (in neither of the combo boxes) . However, when I click within the combo box dropdown area, the value - as it should appear - is populated in the field


Combo Box wont save data to Form
I am trying to have a text box that updates when a combo box dropdown selection is made. Basically the dropdown has the choices from column A and the textbox should display the value in column B.

When I click to go to the next record I have all the data being saved on a table. I had most of this working at one point but now I screwed it up I had it where the text box was updated to show the column B value and everything would save to the table EXCEPT that text box value.


Adding to combo box
What is the best way for a user to add a name to a combo box list? I have a combo box on an inventory form that has a row source from the manufacturers table. Occasionally a part will come in from a manufacturer that is not in the dropdown list. Is there a way for the users to just type the name in the box, adding it to the table so it will show up in the dropdown list the next time it is needed? There are only 2 users that add inventory to the tables, so I don't mind them being able to add names, but I would prefer they not have to physically go into the table to do it


Form combo dropdown
I'm wondering if the following logic should work. I don't want to waste too much time on it, if it's an impossibility.

I have a form on which I have 2 combo boxes. I want the 2nd combo box to filter it's list depending on the value in the 1st combo box. I know that this works for tables that have been set up with primary key --> foreign key on the value that is contained in both.

Where I have a problem is that I would like to set up the above using a table and a join query. If possible.

The reason I have a join query is that I have 2 unrelated tables that need to be listed in the dropdown and by joining them I am adding the filter field. This works fine for the dropdown on it's own, but I can't get the filter to work, and I think it may be because I can't get the relationship right


Combo box display
Is their anyway to have the combo box list displayed without having the user click on the down arrow? Within the controls, I have AutoExpand set to yes.


Remove the non combo box
I added a Combo Box after the Form was created. There are now two fields that say "Vendor" the original and the Combo Box "Vendor". I'd like to remove the non combo box but when I hide it "Visible = No"...