Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Report Design (2003)

    I'm trying to replicate a word document into a report, but I'm having trouble sizing the controls. One of the boxes on the Word document is exactly 4.2cm wide. Access will only allow me to set it at 4.199cm. Some are larger than what I set them to. Taking this into consideration, the document that originally fit on a A4 page, now takes 2 pages. Is there a way round this.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Design (2003)

    Can you really see the difference between 4.199 cm and 4.200 cm? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

    The dimensions of controls on an Access form or report are stored in twips, where 1 twip = 1/1440 inch or about 0.00176 cm. When you set the width or height of a control, it will always be rounded to the nearest whole number of twips. So you cannot always set the exact size you want, but with a granularity of less than 2/1000 of a cm, there shouldn't be a real problem, certainly not to the extent that you need an extra page. As an example, your text box is 2381 twips wide, or 4.19982 cm. Access displays this as 4.199 cm, but the actual width is just 0.00018 cm off

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Design (2003)

    It's not obvious with one control, but it soon adds up on the report as a whole. I'll just have to make adjustments to all controls to compensate for the loss. Thanks for the information Hans.

Posting Permissions

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