• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

Leave a blank field out of access report

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
Jedeye
Asked:
Jedeye
  • 4
  • 3
1 Solution
 
XLITSCommented:
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
 
JedeyeAuthor Commented:
XLITS - I tried this and it doesn't seem to make any difference
0
 
Rey Obrero (Capricorn1)Commented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
JedeyeAuthor Commented:
Not exactly what I was looking for - and providing a link is hardly worth 500 points - but it will do the job
0
 
Rey Obrero (Capricorn1)Commented:
.. then, you should have not accepted the comment.
0
 
JedeyeAuthor Commented:
I will know in future
0
 
Rey Obrero (Capricorn1)Commented:
i also remember those...
0
 
JedeyeAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now