Suppressing Blank Items

[Guest]

I'm using the address label wizard to create some mailing labels. The query
I'm basing the report on has the following fields:

Name1
Name2
Address1
Address2
CityStateZip
Country (blank if it's USA)

I want them to be displayed in that order, but I don't want there to be a
blank line if a certain field has a blank. For instance, right now a
"standard" address is displaying like this:

Mr. & Mrs. Bill Smith
{blank line - no Name2}
123 Main Street.
{blank line - no Address2}
Newton Falls, OH 44444
{blank line - country is USA}

I want to display that address like this:
Mr. & Mrs. Bill Smith
123 Main Street.
Newton Falls, OH 44444

while still utilizing those fields for other adresses as needed.

Is that possibe? Thanks.

 

[strive4peace]

go to the design view of the report that was created

(make sure not to change the overall dimensions, just work with the
controls...)

Make the HEIGHT property of each control that may not have data in it
small -- like 0.02

make the CanGrow property --> true

close up the space...

here are icons that you can add to your toolbar to help you close up the
spacing...

* CUSTOMIZING YOUR FORM/REPORT DESIGN TOOLBAR:

when you are in the design view of a form or report, RIGHT-CLICK in a
gray area to the right of your menu bar or an icon bar

choose "Customize" from the shortcut menu

in the dialog box...

choose the *Commands* tab

Category --> *Form/Report Design*

slide these icons to the Form Design toolbar:
(they are located about 3 "screens" down in the Commands list)

Align Right -- must have >1 control selected to be enabled
Align Left -- "
Align Top -- "
Align Bottom -- "
Bring To Front
Send To Back

If you don't know what these icons do, while the customize window is
open, click on the DESCRIPTION command button for each one to see what
is does.

to be efficient, the Align button are a MUST for form and report design

the Bring To Front and Send To Back are nice to have too -- since
everything is "layered" and this gives you control on the order

~~~~~~~

It is also a good idea to open the property sheet
(from the menu --> View, Properties)

on the Format tab, you can set values such as width, height, left, top, ...

~~~~~~~

in order to align, you have to have more than one control selected

to select multiple controls:

1. click and drag an imaginary line (or rectangle) touching every
control you want to select and then let go of the mouse

OR

2. click (and drag if desired) in the vertical ruler to select
everything on that extended horizontal line (or rectangle)

OR

3. click (and drag if desired) in the horizontal ruler to select
everything on that extended vertical line (or rectangle)

OR

4. click the first object and then SHIFT-CLICK objects to toggle their
selection status


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*