Expanding a combo box

[Will67]

Hi

I have a couple of combo boxes on a report. Is there any way of enabling
these to expand, perhaps programatically, similarly to text boxes with Can
Grow set to Yes.

Thanks
Will

 

[John Spencer (MVP)]

Not that I know of.

Why do you have comboboxes on a REPORT? What is the purpose?

Normally, you would either have a subreport to show the information or have a
textbox control with the values that you wanted to display (concatenated if
you wanted multiple values).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Will67]

I am using dynamic reports using forms with combo boxes and a filter,
enabling the user to filter reports.

I am not sure if I have done this in the best possible way, but since you
ask why I have combo boxes on my report makes me think I probably haven't. If
I use a text box control I am only able to show the index number of the field
on the report.

Thanks Will

 

[John Spencer (MVP)]

OK. I still have a problem seeing what you are doing and what you want to do.
Are you trying to display the selection in the combobox of the form or are
you trying to display the value of a field in a table.

You should be using a textbox. Do you want to display one value? If so, you
may need to modify the query that you are using for the report. The query
should include the table that the combobox is based on. Then you can get the
value of any column in the table to display in the text box.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

You should only have to add the "lookup tables" in your report's record
source.

 

[Will67]

Thanks John

I have perhaps not explained my situation well, but nevertheless you have
solved my problem - seems so obvious now. I simply had to add the table to my
report's query that held the data from the combo box, this enable any column
to be displayed in a text box control on my report.

Thanks very much for your help.

Regards

Will