No Down-Arrow when Display Contents of List in Browse Form

[Eileen]

I am creating a Browse Records form that will list the contents of certain
fields within each record. Some of these fields are populated from lists. I
want the Borwse Records form to just list the contents without editing. When
I chose to make it non-editable that worked but I still get the down-arrow.
How do I make that disappear?

 

[Beetle]

If by "down-arrow" you mean the drop down at the right side of a combo box,
then just change the control type from a combo box to a text box.

HTH

 

[Eileen]

yes, I did mean the drop-down arrow at the side of the list box. I did a
"Change to" text box (on right click of field since I couldn't see a control
type option among properties) but the field seemed to lose the look-up of
that field and is only returning the ID instead of the Name

 

[John W. Vinson]

yes, I did mean the drop-down arrow at the side of the list box. I did a
"Change to" text box (on right click of field since I couldn't see a control
type option among properties) but the field seemed to lose the look-up of
that field and is only returning the ID instead of the Name

For read-only use, you can (and should) base the form, not on your table, but
on a Query joining the table to all of the lookup tables. This Query will
contain the text field from the lookup tables; use that as the control source
of your textbox.

John W. Vinson [MVP]