Multiple detail items per line

[needafix]

I need to print multiple detail items on a single line when it is not known how many items are in the table. I have seen some old DOS apps do this and the user would like to use the same format to save space. They are right that the line listing will be long as opposed the current format.
Current format:


ID 12A11 12A12 13C00 14T05
10D06 11A66 ect.

I can do the standard Access item per line:
ID
12A11
12A12
13C00
14T05
10D06
ect.

Any ideas?

[dcrake]

You could use Replace(<<[YourFieldName]>>," ", VbCrLf) This will replace each space with a carriage return and line feed. Remember to set your textbox to shrink and grow = true.

David

[needafix]

Thanks for the response. I will try this code but initially it looks like the code would get the current format to the second list. I am actually trying to get it to go the other way. Sorry if I wasn't very clear on that.

[needafix]

I have used your idea but concatenated the fields with a space, using a vbcrlf every five times and it works great. Thanks for your help.