Eliminating blank lines

[Guest]

I am trying to eliminate the blank lines in a report. To be specific, I have 4 fields, one below the other. Top one "Motto", next line "Translation, Next "Unit", and last 'Description. If the motto is in English, the Translation field is blank, and I would like to remove the blank line (close up the report) The label wizard closes up blank lines, but I can't figure out how it does it. I tried a 'OnFormat' expression of IIF(TranslationField = "",[TranslationField].Visible = False,[TranslationField].Visible = True). It would help if I knew what I was doing, but, since that is not the case, any assistance is more than welcome

Scott Hughes

 

[Cheryl Fischer]

Scott,

Try setting the Can Shrink property of your text boxes to 'Yes'.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I am trying to eliminate the blank lines in a report. To be specific, I

have 4 fields, one below the other. Top one "Motto", next line "Translation,
Next "Unit", and last 'Description. If the motto is in English, the
Translation field is blank, and I would like to remove the blank line (close
up the report) The label wizard closes up blank lines, but I can't figure
out how it does it. I tried a 'OnFormat' expression of IIF(TranslationField
= "",[TranslationField].Visible = False,[TranslationField].Visible = True).
It would help if I knew what I was doing, but, since that is not the case,
any assistance is more than welcome!

 

[Guest]

Hi Cheryl,

I tried that. It will shrink to just one line, but will not eliminate blank lines (@#@$u($()!!) It's making mew crazy!

A friend told me to use the 'OnFormat' event, but he might have well been speaking Korean, because I didn't understand a bit of it.

I even went to the 'Barnes and Noble Tech Library' and took a look at the Access books, but couldn't find anything on eliminating blank lines.

Maybe this will trigger something: If I use the Label wizard to create labels, it automatically removes blank lines (If there is space for 2 street address lines and only one is used, it eliminates the blank one (or just moves it to the bottom, since the label size stays the same.)) If I could just figure out how to remove the 'label' status so the line just disappeared, I'd be home free!

Thanks for your help.

Scott

 

[Cheryl Fischer]

Scott,

Also set the Can Shrink property of the Detail Section to 'Yes'.

You may also want to note that if controls are even slightly overlapping,
they will not shrink and if you have several short controls on the left side
of a report's detail section and one tall control, such as an unbound object
frame, on the right side, the controls on the left won't shrink, even if
they contain no data.

If this does not help, then I have not interpreted your question correctly.
Please post back with more detail regarding the design of your report.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hi Cheryl,

I tried that. It will shrink to just one line, but will not eliminate

blank lines (@#@$u($()!!) It's making mew crazy!

A friend told me to use the 'OnFormat' event, but he might have well been

speaking Korean, because I didn't understand a bit of it.

I even went to the 'Barnes and Noble Tech Library' and took a look at the

Access books, but couldn't find anything on eliminating blank lines.

Maybe this will trigger something: If I use the Label wizard to create

labels, it automatically removes blank lines (If there is space for 2 street
address lines and only one is used, it eliminates the blank one (or just
moves it to the bottom, since the label size stays the same.)) If I could
just figure out how to remove the 'label' status so the line just
disappeared, I'd be home free!

 

[Guest]

Hi again!

I'll check, but I think I'm OK on overlapping controls

Here's more of a description (and I can even send a sample of the database, If I could impose on you that much
I am doing a project for a military insignia collectors group, involving finding an insignia using the motto on the insignia

I have 4 fields, "LeftOne" which is the first letter of the motto (first grouping), then the motto and, if it's not in English, a translation field. Those 2 fields make up the second grouping. The detail section holds the unit name field and a description field. All except 'LeftOne' have Can Grow and Can Shrink set to yes

A sample entry would look like thi
A (LeftOne Field) (Sorted and Grouped
ABCDESCF (The Motto Field
We Fix, You Eat (The Translation Field, if the motto is not in english) (This is the field that's killing me
Then, in the detail sectio
First Underground Messkit Repair Battalion (The Unit Name
A Broken Mess Kit and a Wrench (The Description Field

Every thing is fine except then the motto is in English, the Translation field should not be visible (and is

Thanks in advance for any help you can provide

Scott

 

[Cheryl Fischer]

I think I see what may be happening here ...

Your Motto and Translation fields are in the Group Header section. Yes?
Try moving them into the Detail Section.

Also, a quick 'n dirty work-around (because I just don't enjoy banging my
head against the wall as much as I used to), have you considered using the
label wizard to make your report? When I need to make reports that are
"directory-looking", I often use the Label Wizard to get the nice columnar
layout. No rule that says you have to print labels to use the Label Wizard!

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hi again!

I'll check, but I think I'm OK on overlapping controls.

Here's more of a description (and I can even send a sample of the

database, If I could impose on you that much)

I am doing a project for a military insignia collectors group, involving

finding an insignia using the motto on the insignia.

I have 4 fields, "LeftOne" which is the first letter of the motto (first

grouping), then the motto and, if it's not in English, a translation field.
Those 2 fields make up the second grouping. The detail section holds the
unit name field and a description field. All except 'LeftOne' have Can Grow
and Can Shrink set to yes.

A sample entry would look like this
A (LeftOne Field) (Sorted and Grouped)
ABCDESCF (The Motto Field)
We Fix, You Eat (The Translation Field, if the motto is not in

english) (This is the field that's killing me)

Then, in the detail section
First Underground Messkit Repair Battalion (The Unit Name)
A Broken Mess Kit and a Wrench (The Description Field)

Every thing is fine except then the motto is in English, the Translation

field should not be visible (and is)

 

[Guest]

Hi Again

The Motto/translation set are in the Header. I'll try them in the detail. The reason I put them in the header was for grouping (A motto/Translation set may have more than one unit). When I tried the label wizard, it wouldn't group at all (not all that surprising, Iguess, realizing that they're LABELS!)

Do you know of a way to 'disconnect' the report produced by the label wizard from it's label? That way I could get the line eliminated and then add grouping later

Thanks again for all your help. I'll let you know how moving things to the detail works

Scott

 

[Cheryl Fischer]

Scott,

You can use Sorting and Grouping without using a header or footer.

Do you know of a way to 'disconnect' the report produced by the label

wizard from it's label? That way I could get the line eliminated > and then
add grouping later.

There is no need to "disconnect". Just select the Label Wizard from New
Reports. Select a label stock (Avery 5160 or 5162 is a good one). Use the
wizard to place your desired fields on the available rows. The wizard will
also allow you to select Sorting/Grouping. Run the report in Print Preview;
you'll see a nice columnar layout and empty lines will be suppressed. If
you want to add a group header, you can but the nice columnar layout will be
destroyed.

Your best bet is to remove the lines in the report that you want suppressed
if blank from the group header and to put them in detail.


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hi Again!

The Motto/translation set are in the Header. I'll try them in the detail.

The reason I put them in the header was for grouping (A motto/Translation
set may have more than one unit). When I tried the label wizard, it wouldn't
group at all (not all that surprising, Iguess, realizing that they're
LABELS!).

Do you know of a way to 'disconnect' the report produced by the label

wizard from it's label? That way I could get the line eliminated and then
add grouping later.