"Locking" position of fields in relation to "Can shrink" fields

Posted on 2005-03-04
Medium Priority
Last Modified: 2012-08-13
Two related questions:
I created a report using five separate address fields arranged vertically.  I set them all individually to "Can shrink".  They shrink vertically fine when there is no data in one of the fields UNLESS there is data in any field positioned in the area to the right of where these are located.  Is there a way to make these fields shrink as needed regardless of the position of unrelated adjacent fields?


When the address fields shrink as needed, unrelated fields BELOW the block of address fields move UP the same number of rows that the address fields have moved up.  Is there a way to "lock" the position of the unrelated fields below?

I am pretty much a beginner at Access.  I am creating reports in Design View using drag and drop and elements from the toolbox.  I have not gotten into programming statements yet.  So please answer in this context if you can.  Thanks.
Question by:byrneb
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
  • 3
  • 2
LVL 11

Expert Comment

ID: 13462485
I would think that you could solve both problems by creating a sub report for just the address fields


Author Comment

ID: 13462512
Have no clue how to do that but will try to research.  Thanks.
LVL 11

Accepted Solution

Stephen_Perrett earned 1000 total points
ID: 13462732
Basically, all you need to do is create a second report and insert it into the first report.
You will need to link the sub report to the main report using a Key field
If you need help please provide details of the query/table your report is based on


Author Comment

ID: 13464001
Got it.  I created a sub report using data from the exact same table and it appears to link and update fine.  Thank you.

Would you be willing to take a look at another question I posted related to this same project?

LVL 11

Expert Comment

ID: 13464072

Sorry, I looked at your other question but do not have necessary knowledge to help on that!

Glad to help here though!


Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

762 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