'report' and 'text box' don't seem to apply to each other.
The detail section of a 'report' consists of lines with fields in each line corresponding to one record of a query (that's why it's called 'detail'), or calculated run-time for each record.
I associate a 'text box' with a form, and a form definitely is something else as a report.
And why the association with VBA in your question?
Kees
Hello,
I have a query of a bunch of rooms with different color floor tiles in them. Ie.
Room 1 Red floor tile
Room 2 Blue floor tile
Room 3 Red floor tile
I would like to make a report with a field that sorts by tile color and then lists all the room in a single textbox. Ie.
Red floor tile Room 1, Room 3
Blue floor tile Room 2
Any ideas on how to dump the room names into a single text box instead of?
Red floor tile Room 1
Room 3
Blue floor tile Room 2
Thanks,
Dave

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic