Sliding Fields

[naiphan]

Hi,

I have two problem in MS Access report that I needed some help.

1) In report, how do I move each fields up if there is no data in the field? For example, if I have 4 field and if field 2 and 3 have no data I would like to move field 4 up to field 1. Right now it's leave two blank space in between.

2) I would like to do a report in the following format.


A. Fee for the cloth
1. Needle
a. string
b. needle
c. scissor

B. Cloth
1. Store
a. silk
b. cotton
c. sheet

Can anyone tell me how I create the above format as a table of content.

Thanks.

 

[Pat Hartman]

Your example didn't help.

Access uses the CanGrow and CanShrink properties of controls and report sections to control vertical space. You need to set the CanGrow/CanShrink properties for all controls in the detail section plus the properties for the section itself to yes.

Then if there is nothing to print on a line, Access will "pull up" the next line.

 

[benjames_au]

I'm having a similar problem with a mail labels report, where I have 7 fields:

1. Name
2. Position
3. Organisation
4. Organisation 2
5. Address
6. Address 2
7. Location

The problem is that in some instances within my report, there will be blank fields, especially in either Name, Position, Organisation, Organisation 2 or Address 2.

I have ensured that the CanShrink/Grow properties are set to yes in both the detail section and the control boxes. I have also added code to the OnFormat property of the detail section thus;

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.Text119) Then
Me.Text119.Visible = False
Else
Me.Text119.Visible = True
End If

End Sub

I'm still getting of blank space where the fields are null, where I want it to (for instance) drag line 2 up to line 1 where line 1 is null.

I'd have thought it impossible if not for Pat's comment:
"Then if there is nothing to print on a line, Access will "pull up" the next line."

Thanks

 

[Pat Hartman]

Access will only supress printing a line if it is entirely blank and no controls overlap. Also keep in mind that Access will NOT supress empty space that you have left between lines so make sure that you leave the minimum amount of space above and below each print line.