Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    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"

  2. #2
    Plutonium Lounger
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts