Is there a way to make the contents of a text box list out horizontally instead of vertically in a report?
The text box is in the detailed section of the report with the report having a sort group based on this text box's content and is set to run for the current record the main form of the database is currently at. The contents of the text box is a list of current items that are needed for the current record to take.
I have tried several things and just can't seem to figure out if this is even possible.
How good is your ADO\ DAO? You can pass the value that you are grouping by to a vb function you write that selects the column containing all the values you wish to concatenate based on the the balue you passed to it. It then just loops through, concatenating the values to a string.