Avatar of Jass Saini
Jass Saini
 asked on

Displaying records in a subform

I hope that I say this correctly..

I have 27 records in my subform...how do I make the detail window bigger to display all 27 records?  In form view I see only about five records  and I have to use the scroll bar to see the rest.
Microsoft Access

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

Will it *always* have only 27 records to display?

What if it will contain 50, or even 100?
At some point you will be limited to the available screen real estate.
Scrolling was designed to let you see *any* amount of records, without having to dynamically change the size of the form.
Scrolling is fairly standard UI feature.

Is here a specific issue with scrolling?

JeffCoachman
Jass Saini

ASKER
Yes it will always display 27 records for the filters I have set and Scrolling is fine, but my boss wants to be able to display as many of the 27 records as possible.
PatHartman

Did you try my suggestion?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Jeffrey Coachman

Yes it will always display 27 records
Thanks
...Then please continue on with Pat's suggestion..
Sherif Tayseer

Please i need to know how to make subform showing all the duplicate values i mean that i have a table first colum is " Ref " i need when i insert the ref no at the main form i need subform to show all the duplicate records for that no if i entered it before for five times for example to see five records in the subform when i enter the ref no at the main form ?

please i need help it's very critical for my project as i need subform to work like a history for the ref no
PatHartman

Sherif,
Please post your question in a new thread so people will see it.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.