Viewing lookup fields on form without drop down arrows

[Paul]

Hi all,

Is it possible to view lookup fields in a form without the drop down
arrows?

I have a table (tasks) that requires the use of a combo box to allow
the user to select an option but when I show the table in a form
(task_list) I just want to show the data and not the drop down arrows
with all the other options.

Many thanks in advance

Paul

 

[fredg]

Hi all,

Is it possible to view lookup fields in a form without the drop down
arrows?

I have a table (tasks) that requires the use of a combo box to allow
the user to select an option but when I show the table in a form
(task_list) I just want to show the data and not the drop down arrows
with all the other options.

Many thanks in advance

Paul

The only way to hide the arrow is to cover it up with a colored label.

To then show the list, code the Combo box Enter event:
Me![ComboName].Dropdown

 

[Albert D. Kallal]

Actually, you can just base the form on a query. In that query, simply drop
in the 2nd table,a nd drop in the column with the text to display.

for the most part, it is suggested that you avoided lookup fields anyway.
(you use the combo box wizard on a form to achieve the same results, but
when you actually don't want the combo box (to display the id used), or in
your case, not have a "dropdown" control, then using a query, and having
avoided the lookup field in the first place would resolve this issue..

do remember to make the sql join a left join.

And, use caution, as that field can still be edited, but you will in fact be
editing the actual text value, and you likely don't want to do that (so, set
then enabled setting of that text box to no....

 

[Paul]

Thanks Fred and Albert - covering the arrows works well but have taken
Alberts advice and removed the lookup fields and gone with comobo boxes
on the form.

Thanks once again.

Paul