Combo Box field - can I make it grow?

[RIM-Pro]

I think I already know the answer to this one, but here goes anyway: I want to change a field in my report into a Combo Box but in previewing the report, all of the data doesn't show up in the Combo Box field. So, my question is: Can I make it grow?

The "Can Grow" option doesn't appear in Properties as a selection for this Combo Box field, so I suspect that I cannot make it grow. If I can't make it grow, is there a workaround outside of changing the size of the field?

Thanks.
Earl

 

[RuralGuy]

I'm not sure what the question is since ComboBoxes do not work on reports anyway. Why change it to a ComboBox?

 

[RIM-Pro]

Actually, I've used Combo Boxes in reports for quite some time now, so they can work as long as you map them to the correct Control and Row sources. I'd just like to figure out a way to make them grow so that they will expand to display ALL of their data without having to resize the box.

The "Can Grow" property of a Text Box in a report can be set to Yes and you don't have to resize the Text Box to accomodate the growth, and I'm just trying to find a possible workaround for growing a Combo Box. Perhaps this isn't possible.

Thanks.
Earl

 

[Pat Hartman]

To show the "lookup" data on the report, you need to use a query with a join to the lookup table as the RecordSource for the report. That will allow you to select whatever columns you need from both tables.