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

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

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?

Related:

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.
0
byrneb
Asked:
byrneb
  • 3
  • 2
1 Solution
 
Stephen_PerrettCommented:
I would think that you could solve both problems by creating a sub report for just the address fields

Steve
0
 
byrnebAuthor Commented:
Have no clue how to do that but will try to research.  Thanks.
0
 
Stephen_PerrettCommented:
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

Steve
0
 
byrnebAuthor Commented:
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?

http://www.experts-exchange.com/Databases/MS_Access/Q_21324720.html
0
 
Stephen_PerrettCommented:
byrneb,

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

Glad to help here though!

Steve
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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