Removing the drop-down arrow on a combo box

[ind]

How do I remove the drop-down arrow on a combo box, so it will look like a text box????????

 

[WP]

right-click on it and change to a text box. <br>
<br>
Or do you mean that you still want it to behave like a combo box ?<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[ind]

Yes I want it to behave like a combo box

 

[elizabeth]

what are you trying to accomplish?

 

[ind]

I want to use a command button instead of the drop-down arrow to expand the combo box.

 

[DougP]

The Arrow in a combo box gets there from a .DLL call to some file we don't know about.<br>
So NO you can't get rid of it.<br>
Unless you Know &quot;C&quot; language and you want to design your own .OCX.<br>
Now to drop down a combo box requires an API call.<br>
I have on but it does not work in Access just Visual Basic Pro<br>
But here it is if you want to fiddle with it.<br>
the first line goes in a Module<br>
---------------------------------------------<br>
Declare Function SendMessage Lib &quot;user32&quot; Alias &quot;SendMessageA&quot; (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Long) As Long<br>
---------------------------------------------<br>
Private Sub Combo1_GotFocus ()<br>
Const CB_SHOWDROPDOWN = &H14F<br>
Dim Tmp<br>
Tmp = SendMessage(Combo1.hWnd, CB_SHOWDROPDOWN, 1, ByVal 0&)<br>
End Sub<br>
<br>
the second lines go in some event in Access Of course there is no &quot;Combo1_GotFocus&quot; event in Access <br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[rhicks]

Use a rectangle to cover the dropdown arrow. Fill the rectangle and set the border to the same color as the form. This will give the appearance that there is no dropdown arrow.<br>
<br>
HTH<br>
RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[rhicks]

Just another thought, in case you didn't know.<br>
To get the dropdown of the combo box using a button, use the follwing code:<br>
<br>
Private Sub cmdDropDown_Click()<br>
DoCmd.GoToControl &quot;YourCombo&quot;<br>
YourCombo.Dropdown<br>
End Sub<br>
<br>
Of course &quot;YourCombo&quot; needs to be the actual name of your combo box.<br>
<br>
Good Luck,<br>
RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[WP]

Docmd.GotoControl ? Is this the same as control.SetFocus ?<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[rhicks]

Yes it will achieve the same results, so I guess you could use control.SetFocus in place of the DoCmd.GoToControl. The main point is that the combobox must have focus before the control.Dropdown code.<br>
<br>
RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>