Recent content by collegeprof

Hello again, It took me awhile to get back to this problem but I'm back and the problem is solved. Here is what I did: - verified that all setgrow property settings were yes - verified that all autosize property settings were yes - checked for code and checked for filter settings -...

They are all set to yes. That would have been a nice easy solution :)

I agree the repetitive fields are not the way to go. I wonder if the original person who worked on it simply imported from excel. I will look at the fields and the controls. I will upload a version as well. Thanks.

The Can Grow is set to true for all subreports. The main report itself doesn't have a Can Grow as far as I can see. Thanks

The main report doesn't seem to have a Can Grow property. It does have Auto Resize which is set to yes. It makes sense to me that you need to see the database. It will take me awhile to pair it down and remove confidential data. I inherited the database and it has a lot of objects in it. I...

All sections of each subreport have the Can Grow property set to yes. Thanks

Sorry, I just realized the code I was seeing in the code window was for the form not the report. The only code for the report/subreport is Option Compare Database.

The only code in the code builder window is code generated by Access. Thanks.

If I enter the first and last name of the client, it displays the full report for that client successfully (in report view, not print preview). In what way is it not normalized? Do you have a suggestion of what I should do next? Thank you.

I checked the main report. The subreports are in the detail section. The page header contains only a small image. I checked the subreports. All data is in the detail section on the subreports. Thanks.

The record source for the main report is a query. There is no defined filter but filter on load is set to yes. I tried setting it to no just in case and it didn't change the result. The record source query contains many fields and has two parameter values that are entered when the query...

Hello, I have a report with multiple subreports. The report looks perfect in report view with enough data to fill many pages. When switching to print preview, page 1 of the report is displayed correctly. However the report stops at page 1. In print preview, if I switch the paper size from...