October 7, 2008 09:37am pdt

1. boag2000 376,752
2. LSMCons... 140,342
3. capricorn1 120,636
4. DatabaseMX 115,400
5. peter57r 102,421
6. harfang 93,096
7. jimhorn 71,175
8. eghtebas 55,025
9. GRayL 49,794
10. irudyk 36,300
11. matthews... 33,769
12. omgang 33,682
13. koutny 32,548
14. TextReport 31,290
15. OnALearn... 29,643
16. hnasr 28,082
17. LennyGray 26,100
18. frankytee 25,140
19. JDettman 22,350
20. JimFive 19,078
21. Rick_Ric... 17,825
22. jefftwilley 17,474
23. puppydog... 15,550
24. ldunscombe 15,380
25. mbizup 14,935

1. boag2000 422,596
2. capricorn1 220,836
3. DatabaseMX 204,070
4. LSMCons... 191,760
5. peter57r 175,461
6. harfang 166,724
7. jefftwilley 152,312
8. jimhorn 139,747
9. matthews... 89,069
10. GRayL 84,879
11. eghtebas 72,425
12. mbizup 70,895
13. frankytee 58,440
14. JDettman 54,830
15. OnALearn... 54,610
16. omgang 53,282
17. stevbe 51,181
18. LPurvis 39,295
19. koutny 38,748
20. irudyk 36,300
21. ragoran 35,150
22. puppydog... 35,005
23. TextReport 34,916
24. LennyGray 30,900
25. nico5038 30,680

05.06.2008 at 10:15AM PDT, ID: 23380200

	[x] Attachment Details

Sizing a report field's height based on user option

Asked by williampeck in Access Reports, Microsoft Access Database, Access Architecture/Design

Tags: Microsoft, Access 2003

I'm trying to allow the user the option of printing 0 lines, 5 lines, 10 lines, or all Notes (memo field)

The solution in here http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_23076043.html
was to
- make the field CanGrow = No, CanShrink = Yes, and
- Set the textbox to its maximum size in the report design.

So I set the text box to ~5 lines.

If the user selects 0 lines, the Notes field is hidden and collapses to 0 height and the sub-reports should move up fill the space, that's what I expect.

But the space isn't re-captured, see attached.

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

           
           
             Select Case Forms!frmReports.cboNotesSelection
    Case "None":
        Me.Notes.Visible = False
        Me.Impact_Label.Caption = "Impact"
End Select
 
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
        
    Select Case Forms!frmReports.cboNotesSelection
        Case "None":
            Me.Notes.Height = 0
        Case "5 lines":
            'field is fixed in design view at proper length
        Case "10 lines"
        Case Else:
            Me.Notes.CanGrow = True
    End Select
End Sub
           
         

Attachments:

AccessQuestionReportFieldSize.doc (126 KB) (File Type Details)

Screen print of report design and output

Keywords: Sizing a report field's height based on…

	Title
1	Height of OLE objects in reports
2	Textboxes of the same height
3	CanShrink jpg on a report
4	CanShrink problem
5	RTF2 CanShrink Property? FMS Total…
6	Height formatting of cangrow objects

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Sizing a report field's height based on user option

Asked by williampeck in Access Reports, Microsoft Access Database, Access Architecture/Design

Tags: Microsoft, Access 2003

About this solution