Multi-page access report won't print

[jackiefm]

I have an Access database front end/backend situation. The users create a record in the main form and add subrecords in the subform. When complete, they print a report that is very often multi-page but the report will only print the the subform records which will fit on the first page for some users. Can anyone tell me why that would be?

[jaxjagfan]

Are you printing the forms or an actual report?. Forms take a bit more work to print records and subforms and get everything you need printed. Especially if the subforms contain multiple records and scrolling.

Design a report with a sub-report and use a command button to print this report on demand.

[jackiefm]

Are you printing the forms or an actual report?. Forms take a bit more work to print records and subforms and get everything you need printed. Especially if the subforms contain multiple records and scrolling.

Design a report with a sub-report and use a command button to print this report on demand.

I actually designed a report and created a button that prints the report based on the open record. Some computers will print the multiple pages and most will not. I cannot seem to find anything common that would prevent one pc from printing all of the subform records and others not.

[jaxjagfan]

Try refreshing the data. The current info entered into form/subform is not actually stored in the table (nor available for reports) until a refresh, requery, or you navigate to the next record.

[jackiefm]

All the data is refreshed before the report is printed. This seems to be pc specific. It is not an issue with the database itself. Everyone uses a copy of the same front end however it works for some and not others. It is either something that needs to be installed on the pc or for Access...Even the IT guy can't figure this one out. There is not user security set up on this database either.

[jaxjagfan]

Take a look at the default printer drivers for each user. Some of my users default to an HP Laser whereas others default to an IBM.

[jackiefm]

We are all defaulted to the same printer. We are all in the same department.

[missinglinq]

These type of problems are usually driver related. Maybe there's a difference in the driver version between PCs that work properly and those that don't, and it's not always the latest version that works correctly! Often, the problem comes because a driver is updated.

Welcome to TheScripts!

Linq ;0)>