Spacing issue with MS Access report

[Tom]

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

[Salad]

Re: Spacing issue with MS Access report

Tom wrote:
[color=blue]
> 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[/color]

Make Field1 bid enough to store the information and set the CANGROW
property to NO.

If you need it to grow, then make entry1...entry4 on 1 line and put
Field1 under that row.

[Ray]

Re: Spacing issue with MS Access report

tfschaub@yahoo. com (Tom) wrote in message news:<b3d1691b. 0404292052.79ba e87c@posting.go ogle.com>...[color=blue]
> 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[/color]

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