Display Multiple Attachment in Report?

[alaingomez]

I would like to ask about on how to display my attached pictures to my report. I'm using MS Access 2007 and I have a table names:

Projects - ProjectID, ProjectName, StartDate, EndDate;

Task - TaskID, ProjectID, TaskName, Pictures;


Picture datatype is Attachment and it is multi-valued field so I created a query to extract picture per ProjectID and to be used as a Subreport. Query results shown below:

ProjectID Attachment
11 tulip.jpg
11 hill.jpg
10 panda.jpg
10 shark.jpg

Now, I have created the sub report and linked it Project table. Result is the pictures add up vertically or downward where there is a big space on the right side, I want to have it from left to right or horizontally. If there is a vb code please include so.

 

[vbaInet]

If it's left to right you need to change the Columns setting of the report.

 

[alaingomez]

Please elaborate the answer

 

[vbaInet]

http://lmgtfy.com/?q=multiple+column+report+++ms+access

 

[alaingomez]

It really works when I check print preview and printed on it but when your not on print preview, still pictures stack up vertically. Is there any method aside from using Page Setup?

Thanks anyway for your quick responses, highly appreciated

 

[vbaInet]

You mean when you're in Report View?

 

[alaingomez]

Yes in report view, it is only one column. But if you click print preview, it will show the correct horizontal arrangement.

 

[vbaInet]

Columns don't work in Report View. I can probably think of a trick. How many columns do you need?

 

[alaingomez]

Two Columns

 

[vbaInet]

Throw together a sample db and I'll take a look.