Report Style/ Formatting

[bloodycape]

I would like to generate a summary report that looks like an excel style table (Rows and columns with lines seperating the cells). I would like the row height to be dynamic, so that all the cells in that row are the same height as the largest cell in the row. any help would be appriciated, thanks

 

[opvk]

I have a silly idea but i do not know if that is going to help you out.
Create the report in the tabular form and then open it in the design mode and add a horizontal line below the record in the details sections. Also I think in the tools or in the properties section u can have the option to make the column width variable (or something like that i guess!). try this silly idea and let me know

Winners don't do different things
They do things differently

 

[alvechurchdata]

Another silly idea<g>.

Export the data to Excel and use Automation to print the sheet.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dhookom]

Use the Line method in the On Print event of the report section to draw verical lines.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]