Remove Drop Down Arrow

[Kevbro7189]

I have a form that has some Look up Fields, they were previously filled in
and I don't want the data changed (I have that part figured out). My problem
is the drop down arrow is still there. Is there a way to get rid of this
annoying arrow?

 

[Klatuu]

No

 

[fredg]

I have a form that has some Look up Fields, they were previously filled in
and I don't want the data changed (I have that part figured out). My problem
is the drop down arrow is still there. Is there a way to get rid of this
annoying arrow?

By Look up field I assume you mean a Combo Box.
All you can do to not show the arrow is place a small label over it.
Set the label back color to the color of the form (or the combo box).
Set the label BackStyle to Normal. Then, click on Format + Bring to
Front. The arrow will not be visible until/unless the user clicks in
the combo box.

Other than that, if you don't wish anyone to make changes or even see
the drop down list, why not simply set the control's Locked property
to Yes and it's enabled property to No.

 

[Arvin Meyer [MVP]]

I have a form that has some Look up Fields, they were previously filled in
and I don't want the data changed (I have that part figured out). My
problem
is the drop down arrow is still there. Is there a way to get rid of this
annoying arrow?

Set the Enabled property of the combo box to No, and the Locked property to
Yes, now create a small rectangle box with the same color border and fill as
your background and cover the arrow box with it.

 

[Kevbro7189]

Thanks, I have made the fields locked. I'll give the "Cover up" technique a
shot.

 

[Arvin Meyer [MVP]]

They have to be disabled. The only way that they won't change appearance is
to also lock them.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com