Formatting of Report in Access 1

[4304]

I have a report that contains several columns and rows of information. Is there a way to have the columns and rows seperated by a single line, similar to an excel spreadsheet when gridlines are printed?

 

[dhookom]

Have you tried displaying the borders of your text boxes and labels?

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]

 

[4304]

Thanks for your advice. I did try this option, but since the information is so different in size and length, it gave me several different "squares" with gaps and they are very inconsistent. I was looking for more of a table type format.

 

[dhookom]

4304,
Next time, it would help to state upfront that you tried the obvious solution so no one wasted their time replying with something that would not work. Also, it would have helped to understand that your controls might grow vertically.

You can use the line method in the On Print event of your report's detail section. You would need to find the tallest "grown" control and use this height to draw boxes in the detail section.

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]

 

[4304]

Next time, it would help to state upfront that you tried the obvious solution so no one wasted their time replying with something that would not work. Also, it would have helped to understand that your controls might grow vertically."

My apologies. I actually did not try it until you told me to. I was just letting you know what happened after I did it. I did not mean to cause any confusion nor did I try to offend anyone.

The On Print event did it perfectly. Thanks again for the advice!

 

[dhookom]

Sorry, I thought you might have tried prior to your first posting. I think this happens quite often in these forums.

Glad you got the On Print to work.

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]