Results 1 to 2 of 2
2008-08-04, 11:12 #1
- Join Date
- Nov 2001
- Brisbane, Queensland, Australia
- Thanked 0 Times in 0 Posts
Drawing horizontal lines in Detail Area (Access 2003 xp sp3)
I have a report with a fixed header and footer size and a sub header of variable size. What I want to do is generate horizontal lines for writing on 1cm apart in the detail section. How can the size of the detail section be calculated.
I have in mind to create Do / Until loop that generates the lines at 1cm spaces until it runs out of space. I just don't know how to determine the size of the detail space per page.
Thought - A standard page will be a set height. Can I call the height of each header and footer, subtract it from the total height and then set the detail height to the result and then use that result as the max height in my Do/Until loop?"Heading for the deep end"
2008-08-04, 18:04 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Drawing horizontal lines in Detail Area (Access 2003 xp sp3)
Can you provide more information?
- Does the detail section contain controls?
- What is the setting of the Can Grow and Can Shrink properties of the detail section?
It might help if you could post a stripped down copy of your database. See <post#=401925>post 401925</post#> for instructions.