Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    setting pageheader hieght with vba

    i have 2 rows of labels in my page header, i would like to hide the second row sometimes, but this leaves a big blank in my header, i tried

    me.PageHeader.Height = 1.7917

    but i get a compile error " Invalid qualifier"

    also, can i set the height smaller than the lowest group of labels in that area if i set thier visible = false?

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Me.PageHeaderSection.Height = 1.7917 * 1440

    Always remember....When in design view the Properties deal with Inches (or cm) but in code...you need to convert to Twips. 1" = 1440 Twips.


    to your second question...No. You will need to reduce their size as well.

    .
    Last edited by CyberLynx; 11-19-07 at 23:00.
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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