Access Report Displays Number from Drop-down vs. Text

[MarkBStewart]

I am producing a report in access. I have a field in a table that is a "Look-up Column". When I add the column to a report it prints out the line-item number vs. the text. For example if I have 3 items in the lookup:
1 Entry 1
2 Entry 2
3 Entry 3

The number 3 prints out vs. "Entry 3". How do I get the content of the column to print vs. the positional number?

Thx

[patjones]

Open the report in design view and click on the control in question. In the property sheet for the control, you should set the column widths property to 0";1" (or whatever width suits you for the second column...as long as the first column is zero-width). This will force the first column to disappear and only the second column to display.

Pat

[MarkBStewart]

access report displays number from drop-down vs. text

Hi Pat

My problem is not that I want the control to be invisible. I want the content of the dropdown to appear vs. the positional number.

To make the control invisible I could set the visible property to "Not Visible". I need the content to display vs. the positional number. Does that make sense?

Thx

[MarkBStewart]

access report displays number from drop-down vs. text

One thing I was doing inthe report is I was gruping on the "dropdown" control. Once I removed the grouping the content appeared as expected.

Thx

[patjones]

Hi Pat

My problem is not that I want the control to be invisible. I want the content of the dropdown to appear vs. the positional number.

To make the control invisible I could set the visible property to "Not Visible". I need the content to display vs. the positional number. Does that make sense?

Thx

My suggestion will not cause the entire control to disappear. It will simply cause the ID column part of the control to disappear. This is generally how one sets up a drop-down list in a form, for instance: it causes the user to see only the content column of the drop-down and not the ID column.

Pat