Remove dropdown arrow from read-only combo box
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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.
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?
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?
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.
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?
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.