Vertical ScrollBar of subreport (on main form) Not shown

[taifoor]

Hi,

Can anyone help please.

I have a main form with a subreport.
Mainform width is 22"(Maximum)
Subreport Wdth is also 22" (Maximum)

When i run the mainform, the subreport shows correctly but the vertical scrollbar is at most right side of main form so i have to scroll main form horizontally first to access the vertical scroll bar of subreport.

To solve, changing subreport orientation to right-to-left shows vertical scroll bar at most left but still if i scroll horizaontally on mainform, that scrollbar hides as its not freezed.

How can i solve this.
Anyone wants to help may consider ActiveX Control of Microsoft ScrollBars 2.0 .....

 

[vbaInet]

Reduce the width of the subform control or reduce the width of the controls on the subform.

 

[taifoor]

Thanks for your reply. However, I know that reducing the width of subreport to the normal screen size of Laptop solve this issue. But its my constraint to do that as i need many data to present therein.

 

[vbaInet]

If the main form is 22" then reduce the subform to 21.5" and subsequently reduce your fields to fit as well.

 

[taifoor]

You are not getting my Point. Even if subform width is 22", I can see the vertical scroll bar of subreport and also of mainform. But i need to scroll horizontally the mainform to the most right to see vertical scroll bar of subreport. I want this vertical scroll bar of subreport to be visible every time even if the view is at most left side.

You can see that by quickly creating:
1- Form of 22" width
2- Subreport inside the above form of 22" or 21.5" (as u like )
3- Make sure that subreport is bound to table of various records
4- Then Open Form and you will see that subreport vertical scroll bar is at most right side which is out of screen

I am using Ms Access 2013

 

[CJ_London]

you need to size your form and subform to fit the screen so in the form resize event put

 subformname.width=insidewidth-subformname.left

or because of the mainform scrollbar you may need

 subformname.width=insidewidth-subformname.left-250

if you maximise your form then it will then show

 

[vbaInet]

Why are you using a report inside a form anyway?

I understand your point. The subreport/subform control is slightly wider than the main form that's why the horizontal scrollbar is showing up. Again, reduce the width of the subform/subreport control and the horizontal scrollbar will disappear.

 

[taifoor]

Main Form Contains Controls that changes report based on these controls. Also Report Headings are on mainform so that the heading freezes when subreport is scrolled down.

Its not possible that Subreport width can be wider than MainForm Width. Moreover, you said that horizontal scrollbar will disappear! I am not concerned with that. I just want to show vertical scrollbar of subreport on screen when it is out of screen. Have you got my point now?

In short, I want to freeze the vertical scroll bar of subreport at left or right side.

 

[vbaInet]

You can look into the Anchor menu on the ribbon. That allows your subreport to grow/shrink appropriately thereby allowing the vertical scrollbar to remain fixed (depending on which Anchor setting you choose).

 

[taifoor]

That have no impact on my problem.

At my own, i was trying to add manual scroll bar AxtiveX control and trying to link that ActiveX scrollbar with subreport. then I can place that scroll bar anywhere in my mainform.

Can anyone help me in designing manual scrollbar for subreport?

 

[CJ_London]

the sample db in this link uses activeX scrollbar so take guidance from there

http://www.access-programmers.co.uk/forums/showthread.php?t=243278

with regards my suggestion - I use it all the time, so suspect you did not maximise the form

good luck with your project

 

[taifoor]

Thanks CJ_London. However, I have already seen through such type of example in which ActiveX Scrollbar is linked with form records. I want to link with a Report (Subreport). By the way, i will try to make it compatible with report too......Till that, if you have any other suggestion, please do let me know.

 

[taifoor]

I am not able to find solution as i dont know much about coding. Kindly guide.

 

[CJ_London]

regret I avoid activex controls so cannot advise. recommend you look at the suggestion I made in an earlier post to use code to resize the mainform and subform so it fits on the screen

 

[vbaInet]

That have no impact on my problem.

What does this mean? And which options did you actually try?

 

[taifoor]

regret I avoid activex controls so cannot advise. recommend you look at the suggestion I made in an earlier post to use code to resize the mainform and subform so it fits on the screen

Resizing the subform is not an option as i want to show alot of information in the report that needs maximum width.

Alternatively i have used to include the button and on click event of these buttons, i scrolled the subform up and down. But the scrollbar is much better as it shows the location of current screen of subreport too with the inside bar of scrollbar.

 

[CJ_London]

I suggest you try it before you dismiss it - providing you allow the horizontal scrollbars, it will do what you require

 

[taifoor]

I suggest you try it before you dismiss it - providing you allow the horizontal scrollbars, it will do what you require

I got your point and I have already tried it. Problem in this is, as i already mentioned that the headings of report are on mainform (in order to let them freeze), scrolling subform horizontally disturbs the alignment of data with headings.

If you can help me in freezing headings inside subreport, then your suggestion will solve the problem.

 

[CJ_London]

and as has been suggested before - rather than using a report as your subform, use a form - and put the headers on the subform?

I do seem to recall an example of a scrollable report - so the headings did not 'go up' the page. Can't find the link but trying googling 'access scrollable report' or similar. If I remember correctly the headers were in a non scrollable report and the data was in a scrollable subreport.

Sometime you cannot do what you want to do and have to find another way.

I'm now out of ideas, so good luck with your project

 

[taifoor]

I am bound to use report due to its grouping and sort function.

Moreover, i have seen an example you are talking about in which two reports are opened simultaneously and one report is popped out and is positioned on top of report to make it freeze. But this trick have other limitations ang bugs, so i haven't used that trick.

If you are talking about some other example, Do let me know.