Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Course Of The Month
2 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Picture Control spans 2 pages in a report
Posted on 2011-03-04
I have a report which prints information relating to a Stock Record. Generally speaking, the report header occupies about a third of the first page, then the repeating detail section can contain any number of photos which are printed also. ie 1 photo per record in the detail section. I have deliberately sized the picture control so the height is just under a half of the page height. So under normal circumstances, we get the header and first photo on page 1, and then pairs of photos on subsequent pages. The picture is not a bound control. The detail section contains a hidden bound text box control. This text box contains the path to the image file. Then in the OnFormat event of the report, I set the picture to display the required image.
However, there is a subreport in the header section which means that the report header can grow in height. If the report header grows to more than half the height of the page I would expect that the first photo should jump down onto the second page. But what actually happens is that Access prints part of the photo on page 1 and the remainder of the photo on page 2. I have got the Keep Together property of the detail section set to true.
So how can I stop this photo from spanning 2 pages?
However, there is a subreport in the header section which means that the report header can grow in height. If the report header grows to more than half the height of the page I would expect that the first photo should jump down onto the second page. But what actually happens is that Access prints part of the photo on page 1 and the remainder of the photo on page 2. I have got the Keep Together property of the detail section set to true.
So how can I stop this photo from spanning 2 pages?
[X]
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
2-
2
4 Comments
Active today
You'll need to place page break control in the detail section and make it visible if your too far down the page. Place the control at the top of the section.
You can determine where you are by the .Top property.
i.e. If Me.Top > x then
me.pgBreak.Visible = True
Else
me.pgBreak.Visible = False
JimD.
You can determine where you are by the .Top property.
i.e. If Me.Top > x then
me.pgBreak.Visible = True
Else
me.pgBreak.Visible = False
JimD.
So page breaks dont have any effect if they are invisible? I didn't know that. I'll give it a go.......
Active today
<<So page breaks dont have any effect if they are invisible? I didn't know that. I'll give it a go....... >>
Yes. If the page break control is not visible, it's not processed.
Not sure I understand why KeepTogether didn't work, although it is ingored if the section won't fit on a full page. That doesn't sound like that's the case though, which is why I'm a bit confused on that. makes me think something else it going on. But try the page break.
JimD.
Yes. If the page break control is not visible, it's not processed.
Not sure I understand why KeepTogether didn't work, although it is ingored if the section won't fit on a full page. That doesn't sound like that's the case though, which is why I'm a bit confused on that. makes me think something else it going on. But try the page break.
JimD.
Yes that seems to work. I might need to tweak the value of x a little yet though.
I was confused at first because when I look at the page break properties window, the visible property is not listed although I can change it programaticaly.
I too wondered why the keep together property is not looking after me. I thought maybe it was because the picture control is unbound. So I made the height of my hidden text box the full 13cm height of the detail section. This had no effect either.
Anyway it's working now. Thanks for your help.
Ian
I was confused at first because when I look at the page break properties window, the visible property is not listed although I can change it programaticaly.
I too wondered why the keep together property is not looking after me. I thought maybe it was because the picture control is unbound. So I made the height of my hidden text box the full 13cm height of the detail section. This had no effect either.
Anyway it's working now. Thanks for your help.
Ian
Featured Post
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…
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security
- Security, *Phishing
AutoNumbers should increment automatically, without duplicates. But sometimes something goes wrong, and the next AutoNumber value is a duplicate. This article shows how to recover from this problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Course of the Month2 days, 19 hours left to enroll
696 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.