Solved

Leave a blank field out of access report

Posted on 2011-09-09
8
339 Views
Last Modified: 2012-08-13
I have an access report that I use to print address labels - it pulls data from a table that has the usual "Address1" "address2"  "City" etc - often there is no data in the "address2" field.
When the labels print this leaves a blank line between "Address1" and "City". I want to be able to leave out the "address2" field when it is blank and have the fields below move up to fill the blank space - any advice on how to do this?
0
Comment
Question by:Jedeye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 7

Expert Comment

by:XLITS
ID: 36509637
It's been a while since I've done this but I think on the detail part of the report i you choose properties there should be "can shrink" and "can grow" properties.  If you set both of these to yes I believe that will do what you want.
0
 

Author Comment

by:Jedeye
ID: 36509687
XLITS - I tried this and it doesn't seem to make any difference
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 36510061
you need to use some codes with the can shrink property, see this link

How to eliminate white space in reports with CanShrink and code in Access
http://support.microsoft.com/?kbid=299011
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Closing Comment

by:Jedeye
ID: 36510242
Not exactly what I was looking for - and providing a link is hardly worth 500 points - but it will do the job
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36510272
.. then, you should have not accepted the comment.
0
 

Author Comment

by:Jedeye
ID: 36510416
I will know in future
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36510498
i also remember those...
0
 

Author Comment

by:Jedeye
ID: 36510587
capricorn1: -
Just so I am not misunderstood - I do thank you for the solution - it worked for me (with some tweeking because I had to translate it into an SQL query) - my comment on the shortness of your contribution was not meant as an insult - also - I accepted the answer because it worked  and I want to move on - I am not familiar with the protocol for not accepting an answer - I meant exactly what I said  - "I will know in future" - by this I mean I will look up the protocol and apply it in future.
Sorry if I caused annoyance
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question