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.

 

[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