Display Records Horizontally in Subform

[wchelly]

I am trying to display records horizontally in a subform. I've tried adjusting the # of columns, but I'm having two issues. I don't know how to adjust the size so that it's not just a very large page, AND it only displays horizontally when printing. Not in the actual form.

 

[boblarson]

1. Forms are not designed for printing. Reports are.

2. Displaying horizontally can be a big bear of a problem without some pretty intense coding, unless you can use a Pivot Table but not all data lends itself to those.

So what is it you are trying to display horizontally?

 

[wchelly]

I need to print a bill of lading for one shipment. I need a subform on the bill of lading which lists all seriel numbers....each serial number is it's own record. They need to be listed horizontally but can have several rows.

 

[boblarson]

I would say you should create a report you can print from that form and you can create the field to display as a subreport and use this:

http://allenbrowne.com/func-concat.html

 

[wchelly]

That works!

 

[boblarson]

That works!

Glad to hear.