Solved

Can Shrink using columns

Posted on 2011-09-27
9
333 Views
Last Modified: 2012-05-12
I'm trying to suppress blank fields in the detail of a report that has two columns of data.  See attached file for further explanation.  
EEReportProblem.doc
0
Comment
Question by:KarenPRuskin
  • 4
  • 3
  • 2
9 Comments
 
LVL 84
ID: 36713636
Are those all bound textboxes? In other words, is SS11 a bound textbox, and SS12 a bound textbox, and so on? If so, then I don't see how you'll be able to do this, but then we'd need to know more about your table design. Can you show us the tables you're using as a base for this report?
0
 

Author Comment

by:KarenPRuskin
ID: 36713668
In the query that the report uses, I've got 34fields based on whether the underlying table field is Yes or No.  eg: SS11: IIf([SITE SS11]=Yes,"SS 1.1     SPRINKLER","") where SITE SS11 is the table field.  
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 36713676
Then it would seem that you have an improper design, but that is hard to say without seeing your tables. Could you upload a copy of your database? We don't really need to see any data, just the table structure.
0
 
LVL 26

Accepted Solution

by:
Nick67 earned 250 total points
ID: 36713721
What you want to do there is hard, given what I suspect your table structure is.
There are many, many fields, and one detail section.
CanShrink works on the section in general, and on each control.
What it doesn't do is move any controls whatsoever.
CanGrow moves stuff, forcing it down the page.
CanShrink undoes CanGrow, but won't dynamically re-arrange stuff

For that you must either code, or change your data structure.
In changing your data structure, you'd have an 'InspectionID' and an ItemPresentID
You'd then have one record for each item present in an inspection, where now you have one inspection record and many fields
You wouldn't have the blanks entered, and wouldn't need to suppress them.

Here's a sample to demonstrate the difference
Different-Structures.mdb
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 26

Expert Comment

by:Nick67
ID: 36713734
@LSMConsulting
Lots of folks with denormalized data today!
http://www.experts-exchange.com/Microsoft/Development/Q_27327999.html
Same kind of deal.
0
 

Author Closing Comment

by:KarenPRuskin
ID: 36713784
This database was presented to me to modify the existing reports.  I agree with both of you, bad bad design and may spend some time redesigning the table layout, as suggested.   It's always more than a simple 'report modification' ! !  Anyway, keeps me in a job.  Thanks for your fast response.  BTW, I'm in New Zealand.  Go The All Blacks.
0
 
LVL 26

Expert Comment

by:Nick67
ID: 36713805
Watched the Canucks tie the Japanese last night.
They'll get killed by the All Blacks, of course, but Kleeburger's been fun to watch.
That beard!
Hopefully they finish third in the pool and can have another go around in 4 years.
Incidentally, the local boys (Grande Prairie Alberta Pop. 52,000) won the Edmonton Rugby Union E3 title over the Edmonton (Pop. 1 Miilion) squad on the weekend.
Next weekend they play the Calgary (also Pop. 1 million) squad for the provincial championship.
Good stuff.
Go Canada!
0
 

Author Comment

by:KarenPRuskin
ID: 36713872
Wow, what a small world.  I'm originally from Edmonton so know the places you mention.  My husband (a New Zealander) and I now run a guest house in Whangarei, New Zealand and both the Canadian and Japanese teams managers/coaches stayed with us during their games here (Keiran Crowley, John Kirwan, etc).  Nothing like name dropping!  Good to sing Oh Canada once again with a fanatic crowd and amazing that they got a team together - doesn't resemble ice hockey in the slightest!  Personally, I think rugby is absolutely rugged, no padding anywhere.   Nice to meet a fellow fan in such an unlikely space as EE.  Cheers Nick, Regards Karen.  
0
 
LVL 26

Expert Comment

by:Nick67
ID: 36717803
It's a small world indeed.
Glad to have helped
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
HasData 9 37
Access Report that will show table changes 7 47
Need more help autopopluating a number field 17 34
How do I refer to a session variable in a query? 4 21
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 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

12 Experts available now in Live!

Get 1:1 Help Now