If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > setting pageheader hieght with vba

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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?
Reply With Quote
  #2 (permalink)  
Old
Stuck on my opinions...
 
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.

.
__________________
Environment:
Self Taught In ALL Environments.....And It Shows!


Last edited by CyberLynx; 11-19-07 at 23:00.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On