tf******@yahoo.com (Tom) wrote in message news:<b3**************************@posting.google. com>...
I have a report where one field tends to be rather lengthly and ends
up being several lines long while another field has several short
entries. The problem I have is that the first of the short entries is
aligned with the record's other entries, but subsequent entries are
listed below the first record.
Does anyone know how I can get rid of the annoying gap between the
first and second entry for that one field?
Current:
Field1 Field2
This is a entry1
single desc.
that is long.
entry2
entry3
entry4
What I Want:
Field1 Field2
This is a entry1
single desc. entry2
that is long. entry3
entry4
Hello,
Perhaps one way of resolving this issue it to make
three report.
1. The first is your main report.
2. This is a sub report to display Field 1 only.
3. This is a sub report also to display Field 2 only.
First work on #2. Set up a report and only put in
Field1 text field. Remove any headers not needed and
make sure it's in the Detail section of the report.
Also, make sure the field is set to yes for Can shrink/
Can Grow. Minimize all space around the field in the report
to show only the field.
Repeat for Field2. Make a "third" report to display only
one field: Field2.
Next, create the main report, select the SubForm/SubReport
tool on the tool box. Make sure the Wizard has been selected
before hand. Access will guide you through the steps for
selecting the sub report that will be needed in each "Sub Report"
object being used.
When you get done, you'll have two subreports on your main report.
Set up the subreports in the detail section and treat them as you
would a text field. Make sure both are selected Yes for the
Can Shrink/Can Group property.
Now, run the report. You should see the result according to
your needs.
Regards,
Ray