Report, Combo Box

  • Thread starter Thread starter bandjknutson
  • Start date Start date
B

bandjknutson

When attempting to create a report from a query, one of my record sources is
a combo box. When the report is generated, the field that should be populated
by the combo box text entry is filled by the primary key of the table used to
fill the combo-box.

How can I have this show the text instead?
 
The combo box, unless told otherwise, reads the first column that isn't 0cm
wide
The usual format is to have the ugly ID numbers (that do all the real work)
first, then the nice non-threatening text field and then other fields if
needed.
You can change this by right-clicking on the combo, going to Properties, and
next to column width, set the first column to 0cm.
Also, click next to Row Source to open the query *as the combo box uses it*
and check that the text field is in the second column in design view.
Evi
 
Back
Top