Combo Box dropdown arrow

[Eli]

Is there anyway to hide the combobox dropdown arrow
without having to mask it with another control. I would
like the combobox to look like a label until it is entered
and then offer the drop down. Basically, I would like it
to look like the combobox in MSWord forms.

Thanks,

 

[Jeff Conrad]

The only way I've heard of is to hide it with another text box or label control as you mentioned.
Here are some past posts by Access MVPs Ken Snell, Cheryl Fischer, and FredG on this subject:
If you're trying to hide the drop-down arrow, use a small trick to make it
appear as if the combo box has been changed to a textbox:

Create a box on the form, and size it so that it will fit over the arrow
part of the combo box. Place the control on top of the arrow part of the
combo box. Be sure that it's set to be on top of the combo box control (move
to front). Have the background of this box be the same as the background of
the detail part of your form. Set its visible property to yes.

When the form is viewed, the combo box will appear as if it's a textbox. The
user won't be able to click the "dropdown" arrow because the box prevents
access to it.

In your code, when you want to "turn" the "textbox" into a combo box, set
the visibility property of this box to No. Set it back to Yes when you want
to "turn" it back into a textbox.

See this KB article for more info:

http://support.microsoft.com/default.aspx?scid=kb;en-us;325233
[/QUOTE][/QUOTE][/QUOTE]

If you want to hide the arrow, make a little label of the same color as your
form's back color and position it carefully over the arrow.

Or, in addition to having the locked property = True, set the Enabled
property of the control to False.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

A Datasheet view and a Form View are different.

See Microsoft Knowledgebase article:
'ACC: How to Hide the Combo Box Drop-Down Arrow on a Form'
http://support.microsoft.com/default.aspx?scid=kb;en-us;109724
[/QUOTE][/QUOTE][/QUOTE]

 

[Eli]

Thanks a bunch, sure wish there was a way to vb it.

-----Original Message-----
The only way I've heard of is to hide it with another

text box or label control as you mentioned.

Here are some past posts by Access MVPs Ken Snell, Cheryl

Fischer, and FredG on this subject:

If you're trying to hide the drop-down arrow, use a small trick to make it
appear as if the combo box has been changed to a textbox:

Create a box on the form, and size it so that it will fit over the arrow
part of the combo box. Place the control on top of the arrow part of the
combo box. Be sure that it's set to be on top of the combo box control (move
to front). Have the background of this box be the same as the background of
the detail part of your form. Set its visible property to yes.

When the form is viewed, the combo box will appear as if it's a textbox. The
user won't be able to click the "dropdown" arrow because the box prevents
access to it.

In your code, when you want to "turn" the "textbox" into a combo box, set
the visibility property of this box to No. Set it back to Yes when you want
to "turn" it back into a textbox.

See this KB article for more info:

http://support.microsoft.com/default.aspx?scid=kb;en- us;325233

[/QUOTE]

If you want to hide the arrow, make a little label of the same color as your
form's back color and position it carefully over the arrow.

Or, in addition to having the locked property = True, set the Enabled
property of the control to False.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

A Datasheet view and a Form View are different.

See Microsoft Knowledgebase article:
'ACC: How to Hide the Combo Box Drop-Down Arrow on a Form'
http://support.microsoft.com/default.aspx?scid=kb;en- us;109724[/QUOTE]

--
Jeff Conrad
Access Junkie
Bend, Oregon

Is there anyway to hide the combobox dropdown arrow
without having to mask it with another control. I would
like the combobox to look like a label until it is entered
and then offer the drop down. Basically, I would like it
to look like the combobox in MSWord forms.

Thanks,

.
[/QUOTE]

 

[Jeff Conrad]

None that I'm aware of at this point.
Sorry. :-(

--
Jeff Conrad
Access Junkie
Bend, Oregon

Thanks a bunch, sure wish there was a way to vb it.
text box or label control as you mentioned.
Fischer, and FredG on this subject:

If you want to hide the arrow, make a little label of the same color as your
form's back color and position it carefully over the arrow.

Or, in addition to having the locked property = True, set the Enabled
property of the control to False.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX


A Datasheet view and a Form View are different.

See Microsoft Knowledgebase article:
'ACC: How to Hide the Combo Box Drop-Down Arrow on a Form'
http://support.microsoft.com/default.aspx?scid=kb;en- us;109724

--
Jeff Conrad
Access Junkie
Bend, Oregon




.

[/QUOTE]

 

[Damon Heron]

Eli,
You can add a subform to your form in datasheet view and place your combobox
there. The arrow will not appear until the box is entered. That may not
suit your needs but it is one way. Another is to use the mouse move event
or the enter event to trigger a visible combobox appearing where you have a
label... That's just a thought -haven't tried it.

HTH
Damon

 

[Damon Heron]

Eli,
Since my last post, I played with it a bit. Put a small label with the
forecolor and backcolor the same grey as the combo box, place it exactly
over the down arrow. The label caption can be anything, because it won't be
visible. Then select "bring to front" for the label. When you tab into the
combo box, the down arrow appears -when you tab out, its gone.

Damon