In Datasheet view my combo boxes don't disply the dropdown arrows and
consequently they aren't an eyesore.
Right now my Form view which has combo boxes is displaying dozens and
dozens of dropdown arrows. How can I turn off this display so that it
looks the same as in Datasheet view?
That is, only when a combo box is selected, its dropdown arrow is
I certainly hope that at the very least, I can control this using VB code.
Trying to spiff up my forms and move away from Datasheet view.
If the controls (fields) are actual comboboxes then you are stuck but here is a great way to use dropdowns
1)Avoid lookups (dropdowns) at the table level
2)On a form create your field and using a drop down to fill that field - size the combobox on screen so just the arrow is visible
3)place the down arrow adjacent to the text field to the right
4)after the selecting the data from the combo - have the data populate your field
Now - to eliminate all the arrows set to them to visible = false
On set focus of the field you want to update turn the appropriate dropdowns visible proerty to true
On Lostfocus of that field set the dropdown's visible propert to false
Ah! Continuous forms - therein is the problem - to actually run a good deal of code based on the controls properties you will have to utilize the on current event as well of the form. But making all the down arrows not visible from within the continuous form can only be accomplished with some smoke and mirrors in VB
dblclick the two textboxes within the form and store (pass) those values in two hidden textboxes on the header of the form after the dblclick of the second field and passing that value to the hidden(not visible) control launch the form that looks at the hidden controls for its criteria.