Good day.

I have created a report which lists recipes. A sub-report lists the ingredients. Is there anyway I can make the ingredients display/print, horizontally instead of vertically.

Meaning:
Eggs, Milk, Flour, etc.

Instead of:
Eggs
Milk
Flour
etc


Thanks.


LG

[LGuzman]

__________________
[LGuzman]

I don’t think you are going to be able to do this in a straight-forward fashion; you are going to have to get control of the machine to do this.

The sub report has a field linking it to the record of the report in which it finds itself, so that the subreport is showing data that is actually related to its parent.

I think you are going to have to get ahold of that ID, open the recordset, read it (putting the results into a string, concatenated with commas), and paste that string into the report yourself.

This would probably be best done without a sub report, but just filling in a label or textbox that is on the top-level report.

I think If I were going to do this, I wouldn’t even use an Access report though.
I would integrate with Word through ActiveX Automation, opening an object that was an instance of Word, using that to create and fill in a document.
That would give full access to conditional formatting, fonts, indentation, and so on, as well as Word’s printing routines.

Probably not what you want to undertake, but that is what I would do...