By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,209 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,209 IT Pros & Developers. It's quick & easy.

Spacing issue with MS Access report

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Tom wrote:
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


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.

Nov 12 '05 #2

P: n/a
Ray
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.