473,327 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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
Nov 12 '05 #1
2 2653
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: PMB | last post by:
Thank you in advance for any and all assistance. I'm trying to take 4 fields and space them evenly on a receipt printer. My problem is there are many variables, i.e. Qty may be one or two...
2
by: Tom | last post by:
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...
3
by: ahaque38 | last post by:
Hello. Using A2K SP3, I am having the following problem with a report using "Sorting and Grouping". I have recently added a grouping in the reports for "Category2<>'CONTRACTS'". I have...
2
by: Lumpierbritches | last post by:
Thank you in advance for any and all assistance. I'm trying to create a report that will work similar to the label wizard in Access. I have a premade form I'm attempting to fill with data from the...
24
by: JB | last post by:
Hi All, This is doing my head in! Please help. I've built a simple <ul> to serve as a menu for a page I'm working on. I have tested the menu in Mozilla Fireworks 1.5 and it's fine - nice and...
4
by: metoikos | last post by:
I've scoured the web (clumsily, I'm sure) for information on the difficulties I am having, checked my markup in validators, and had a friend with more CSS clue look over it, but I haven't had any...
4
by: green51 | last post by:
HI i have tracking program that is tracking different projects. It contains date(mm/dd/yy),project name,personnel assigned to the project. Personnel range from 1 to 12 individuals never all 12 at...
1
by: replyrpatil | last post by:
What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in) ...
4
by: Mamluk Caliph | last post by:
For quite some time I've used code as the following to be able to "cut&paste" parts from different headerfiles of the same name. It has worked with GCC, MS, Borland, Keil to name a few. In...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.