Continuous form with non interactive fields

[agent46]

Hello all,

I'm building a continuous form to display product information from records in a single table. Pretty simple. Some of the fields in my table are combo boxes. I would like to display the data in these fields without the combo box functionality. Is there any direct way on a form to simply display the data in a field without the combo box?

Thanks in Advance,


~46

[June7]

Yes, use a textbox. Convert the combobox (right click > ChangeTo) to textbox or drag textbox from the Design tab and set ControlSource.

You must have set lookups in table. I never do that. Review: http://access.mvps.org/access/lookupfields.htm

[agent46]

Thank you. Actually, I need the combo box setting for our data input form, so I don't really want to get rid of the combo box format for these fields.

This other continuous form I'm talking about (above) would be more like a simple scrolling directory of the records, so in this case only, I just want to display the current content of the combo box fields without the combo box functionality.

I hope this is a better explanation of my question.

Thanks.

~46

[June7]

Doesn't matter if the lookup is set in table, can still have combobox on form. Removing the lookup from table will not impact comboboxes already created.

Setting lookup from table just aids in creation of combobox on form. Dragging the field from fieldlist will cause control to adopt properties of the field. Can just drag a textbox from the Design tab and then manually set the ControlSource. Voila! - no combobox features.

[agent46]

Ah! Yes, thanks!

All the Best
~46

[agent46]

You anticipated my next question with this like, although I'm not clear on what exactly it's recommending I do about it. Will post a seperate question. Thanks again.