Help with Grow and Shrink Horizontally. 1

[5835]

In a report I want 5 -6 combo box fields to grow and shrink and make a paragraph. What I get is separated fields. When I pick grow or shrink under properties, it grows vertically, is there any way it will grow horizontally and will look like a typed paragraph.please help, I am sure this is doable.
Thanks

 

[scriverb]

No you cannot do that but there is a way to put all the values together into another text control. You can cancatenate the values together into one string and display it in a single text control with the Can Grow property set to Yes. This control can be stretched horizontally to the size of the paragraph width that you want and then it will grow vertically depending upon the amount of data in the Text Control.

Set the visibile property of the ComboBox controls to No so they are not visible and squeeze them down to nothing in size and tuck them up in the corner of your Detail section to keep them out of the way. Now use this code to reference their values and put them in a single text control.

Me![TextParagraph] = Me![CB1] & " " & Me![CB2] & " " & Me![CB3]

Another way would be to do this all in your Reports Query. Perform the cancatenation process in a new column in your query and then just create another control with that new field as the Control Source.

Let me know if you need more help with this.


Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???