Combo box display

[Claire]

Hi all,
I have a field that is a combo box. It works just as I'd like during data
entry. However, when I put it on a form where I don't want to edit it, or on
a report, I'd like it to look like any other text box. Right now it has the
value highlighted and the two errors to the right of the value (to move up
and down the list). Is it possible to change the display of the combo box so
that it just shows the value?

Thanks,
Claire

 

[Chegu Tom]

It looks like you have made the common mistake of using some of the fancy
options Access provides but can cause you problems and confusion in the long
run. The following points are more important than they may seem. It is
part of good database design.

You should NOT define a field as a combo box in your table!
You should NOT use your table for data input!
You should create a form based on the table for data input
You can put your combo boxes and any other frills in the form
In datasheet view it will look and act like the table does now,

Then the field in your table will be an ordinary field which will display
normally in your other forms and reports.

Tom

 

[Daryl S]

Claire -

Right-mouse click on the control and select Change To and then Text Box.

 

[Claire]

Thank you for your replies! I was completing all my entry on the form, but
had forgotten to use the combo box just on the form verses on the table.
It's all working now!