Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining 3 texboxes in report

Status
Not open for further replies.

Domino2

Technical User
Jun 8, 2008
475
GB
Because of the maximum of 255 lines in a textfield I have 3 textfields on a form allowing reports to be written. This has to be be sent to a report. Because of not knowing how much text has been entered in the 3 textfields it is proving a problem to know the best way to put the fields in a report. I have set the can grow and can shrink to yes, however I wonder if I should trim each field (checking there is something in each one) and joining into 1 textbox having put a space between each field to overcome wasted space.

Is it a viable route?. My report recordsource comes from a listbox on a data entry form

Thanks for any advice
 
I tried doing a trim of each field coming to the report and joining via a " " but not all the data is there. Is a textbox on it's own limited to 255 characters?
 
Solved my problem. I found my grouping and sorting excercise had put my textfield into a header, putting into a detail section together with making my table field a memo I now have more than enough charcacters in a single text field on the report, so enabling the elimination of two other fields in my table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top