groupheader sizing

[RayMilhon]

I have an Access 2010 Report There is a group for specific measures. Some measures contain sub-measures some don't The Report looks something similar to this

Sub-Measures
Adequately Controlled Blood Pressure

Sub-measures
Influenza Vaccination


Measure Diabetes
Sub-Measures
Diabetes Eye Exam
Diabetes HbA1c>9%
Diabetes LDL Screening

The database has a field to specify Whether the measure prints or not and I have the following code in the onformat event of the group header

If  abs(me.ckmeasureprint) = Abs(checked) Then
       me.groupheader2.Height = .17
       me.label6.visible = False
       me.text19.visible = False
       me.label21.top = 0
Else
      me.groupheader2.height = .375
      me.label6.visible = true
      me.text19.visible = true
      me.label21.top = .2083
End if

In the design of the report the controls are set to the Else portion of the above If statement. When I run the report the first record prints the way I want. However, the every time the Else portion of the above if statement executes the label6.visible = true works and the me.text19.visible = true works. The Height does not change and the label21.top stays at 0. Am I missing something?

[June7]

Use TWIP http://en.wikipedia.org/wiki/Twip units, example:

'1 inch = 1440 TWIPS
Me.boxMask.Height = 10710
Me.boxMask.Top = 4320
Me.tbxM1.Top = 4680
Me.lblM1.Top = 4680

[smithse]

Are the sub-measures in a subform? Reports will act this way, and only the first "record" will be affected. Access reports then assume that all pages generated from the same report will for formatted that way.
I have built reports that hide or show certain groups and subreports depending on whether or not there is data in them, but never to hide certain controls in a report that have data in them.

[smithse]

Oh, and another thing too, in Access 2010 if you are using the layout grid to align controls, the sizing will not work. Remove your controls from the layout and try to see if that makes a difference.

[RayMilhon]

June after I posted I realized I'd left the twips conversion off. I did that and the controls now show where they should the issue now is that the section does not resize so I still have a lot of wasted space. Roughly 200 pages given the size of the report and the number of times the blank line is printed to the report.

Smithse do not use the layout grid. No this is a report so sub-forms or sub-reports. Just the main report with 3 grouping levels the resizing is in the 3rd level

[RayMilhon]

Just stepped through the code

If Abs(me.ckmeasureprint) = Abs(checked) Then
     me.groupheader2.height = 0.17*1440
     me.label6.visible = False
     me.text19.visible = False
     me.label21.top = 0
Else
     me.groupheader2.height = 0.375 * 1440
     me.label6.visible = true
     me.text19.visible = true
     me.label21.top = .2083 * 1440
End if

Everything but the me.groupheader2.height works as expected. In both cases me.groupheader2.height shows 540 twips even though the 0.17*1440 = 244.8 not 540 so the header height is not being set in the groupheader2.format event.

[June7]

What happens if you make the groupheader2.Height setting after the label21.Top = 0?

[RayMilhon]

I got it working but not real clear why.

What I noticed is that .017 *1440 = 244.8 and .375 * 1440 = 540
so I changed the .017*1440 to Round(.017*1440,0)+1 and the resizing worked. I'm guessing that the decimal did not allow the resizing to work but No error was generated it just left the setting at 540 doesn't make sense to me but it's working and instead of 768 pages I'm printing 559

[June7]

Odd, I have TWIPS with decimal and doesn't appear to cause issue.

BTW, just in case you ever need it, .Left would be in inches, not TWIPS (don't ask me why!).

[RayMilhon]

I know I've used it before never been an issue until this time. No clue why, but it works. As for the .Left in inches, Not TWIPS. Why? (JK)