Supress Drop Down Values in Report

[Manuel Soares]

I have a report based on a query, which is based on a
table for which there are a few fields which are set-up as
lists - i.e. in the table datasheet view, in the lookup
tab of the popery box, the Display Control reads "List
Box" - I'm using a Row Source Type of "Table/Query"
and "Value List". The Row Source has either values
separated by a semicolon (for the "Value List" option), or
an SQL Statement (for the "Table/Query" option).

When I run the Report, I get all of the various dropdown
values for the fields I've set with List conditions, with
the option selected in the table highlighted. How do I
remove the drop-down values from my report?? I only want
the values selected in my table to populate, not all the
list values with the chosen value highlighted.

Please advise.

Thanks much!

Manuel

 

[Larry Linson]

Well, the first thing you could do is to redefine your table to not use the
very confusing lookup fields -- convenient perhaps for a novice, casual end
user, but with no place in developed applications, IMNSHO, as they just
complicate your life and obscure what is really stored. But, even easier, in
Design View of the report, highlight the control and then on the menu Format
| Change To | TextBox. On the other hand, to get the value you likely want
to show, you will need to join the table to the table described in the
lookup tab, and pull the value from that table into the grid.

Larry Linson
Microsoft Access MVP