Stupid question/listbox to report output

[Ed Heath]

Hi all, a stupid, basic question, that I can't remember
the answer to. I create a list box in a table, populate
the field with selections from the list box, but when I
create the report the selections are blacked out on the
report by a solid black highlight. I have fooled around
with properties, but I have forgotten some basic thing (I
know I ran into this a couple of years ago). The little
fly voice: "Help me".
Thanks,
Ed

 

[Duane Hookom]

What is the Row Source of the list box? Is this a table or query? If so,
include the table or query in the report's record source.
You might want to review how many of us perceive lookup fields defined in
tables. http://www.mvps.org/access/lookupfields.htm

 

[Ed H]

Hi Duane (et al),
I looked at the mvps.org page and so far it hasn't
helped, though I will play some more with what is on
there. I created this problem at work, I believe with a
query and I have been able to replicate it at home with
just a table. I really think (hope) it is a simple
display property issue, something I am missing. The
information from the field does show up in the report, it
is not that the report can't find a field in the table.
The record source shows the table. In fact, if I expand
the field box on the report (indesign view), I can see
the entire list (in the preview view). But the one item
selected information from the list is blacked out by the
highlight. It is probably something so simple most people
have forgotten they automatically fix it (push clutch in,
then shift gear?).
Thanks, Ed

 

[Duane Hookom]

Did you try "include the table or query in the report's record source" that
is the listbox's Row Source?
Do yourself a favor and never use the lookup anti-feature in table designs.

 

[Guest]

Howdy Duane,
Was having the same difficulty as Ed. He was right about the solution being simple. Hey Ed, the only stupid question is the one not asked! The web site you offered held the key, just change the control type to Combo box and ta-da. All my data is now displayed just as hoped. Thanks, Duane and you too, Ed, for the question.
McNie