Solved

Leave a blank field out of access report

Posted on 2011-09-09
8
307 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
  • 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 119

Accepted Solution

by:
Rey Obrero 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
 

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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 119

Expert Comment

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

Author Comment

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

Expert Comment

by:Rey Obrero
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now