Create a "look-a-like" grid in details section

[DriesG]

Hello,

I would like to create some kind of a grid look for the details section in a report.
I want to do this by drawing some vertical and horizontal lines. This gives the nicest effect.
It looks great, as long as the text boxes don't grow.
When a text box grows, then the vertical lines ar too short and the grid doesn't look so good.
I tried to set the vertical lines height through VBA.
On the "On format" command of the details section, I put next script:
line1.height = details.height
The script works, but fore some reason it always returns the height of the details section as it is in the design view of the report and not the actual height.

Any idea how to sole this?

Many thanks,
Dries

 

[dhookom]

To determine the "grown" height, you must use code in the On Print event of the section. Then, use the Line method of the report rather than a line control. I believe the calendar style report in the Corp Tech demos at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

uses this method.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.