Prev: How do I create a query without using a wizard?
Next: Displaying heirarchal relationships in forms
From: Matthew Pfluger on 7 Jul 2008 08:55
I want to take advantage of the query abilities of a combo box within a form,
but I do not wish to display the drop down arrow to the user. I also want
the user to be able to highlight and copy the text within the combo box,
similar to how one could use a locked but enabled text box.

In Excel, when using MSForms, one could hide the drop down arrow of a combo
box to make it look and act like a text box. Is that possible in Access
2007? Thanks.

Matthew Pfluger
From: strive4peace on 7 Jul 2008 14:34
Hi Matthew,

sure! just make a rectangle with the same BackColor and BorderColor of
your detail section -- about .2 x .2 in height and width -- you can just
cover it up <smile>

when the user is IN the control, they will see the arrow, but when they
are not, they won't

If you don't want them to see the arrow while they are in it either,
then use a textbox that shows the column from the combo that you want
and make the Visible property of the combo = No

this will display the second column of the combo (column indexes start
at zero):
=combo_controlname.column(1)


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Matthew Pfluger wrote:
> I want to take advantage of the query abilities of a combo box within a form,
> but I do not wish to display the drop down arrow to the user. I also want
> the user to be able to highlight and copy the text within the combo box,
> similar to how one could use a locked but enabled text box.
>
> In Excel, when using MSForms, one could hide the drop down arrow of a combo
> box to make it look and act like a text box. Is that possible in Access
> 2007? Thanks.
>
> Matthew Pfluger
 | 
Pages: 1
Prev: How do I create a query without using a wizard?
Next: Displaying heirarchal relationships in forms