Share via

Report Page Setup does not transfer

Anonymous
2019-11-21T19:33:32+00:00

I maintain a database for our department and as I make improvements, I copy my database to the other users. It seems like, ever since we started using Windows 10, the page setup I have for labels in my reports does not transfer over to the other users. For example, I have a report saved for a label we send to our DYMO labelwriter printer and on my copy, the page setup Paper size is set to 30252 Address. But when the user opens the fresh copy of my database, the same report has a Paper size of 99015 Diskette. Other labels I have set for 4x6 paper on my copy come out 9X15 on the user's copy. I'd hate to have to reformat and resave every user's reports every time we enhance the database. Any ideas? Thanks in advance.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

10 answers

Sort by: Most helpful
  1. Anonymous
    2019-11-26T18:00:31+00:00

    Dear Landeye,

    Welcome to share any updates when you have time if you need further help on this issue.

    Best Regards,

    Cliff

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-11-23T02:31:31+00:00

    Dear Landeye,

    Thanks for your updates.

    Generally, to create a label, you can first open a blank database>create a table>create a label. Then you can set the page setup settings on the label, export they database file and share it with other users. As the issue seems to be that the page setup settings aren’t kept after exporting the database file in your environment, this is the possible reproducing steps I guess and want to confirm from you in your environment.

    So if the steps aren’t what I mentioned above, could you also list the detailed steps about how you copy the database and how you make the page setup settings for the label? Could you upload some screenshots about “the page setup Paper size is set to 30252 Address. But when the user opens the fresh copy of my database, the same report has a Paper size of 99015 Diskette. Other labels I have set for 4x6 paper on my copy come out 9X15 on the user's copy.” for our clarification? Meanwhile, I’d like to confirm whether the issue happens in a specific file and upload a full screenshot of the Account page in the Access application you are using. You can access the page via clicking on File>Account.

    Note: Remove any private information before uploading the screenshots.

    Best Regards,

    Cliff

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-11-22T13:21:45+00:00

    Cliff,

    When you say...

    "If yes, I’d like you to confirm whether the reproducing steps are the following.

    1. Open a database>create a table."

    ... are you saying open a new database or the one I was referring to that I am currently sharing.

    Thanks.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-11-22T04:48:25+00:00

    Dear Landeye,

    From your description, it seems that the page setup settings aren’t kept in the label when another user opens the file with the Access application on his computer.

    If yes, I’d like you to confirm whether the reproducing steps are the following.

    1. Open a database>create a table.
    2. Click on Create>Report>Label.
    3. Create the label and make the settings on Page Setup.
    4. Save and export the file to a.accdb file.
    5. Share it online or in the network shared folder.
    6. The page setup settings for the label are changed when another user opens the file with the Access application on his computer.

    If yes, I’d like to confirm whether the issue happens in a specific file and upload a full screenshot of the Account page in the Access application you are using. You can access the page via clicking on File>Account.

    Meanwhile, could you also list the detailed steps about how you copy the database and how you make the page setup settings for the label? Could you upload some screenshots about “the page setup Paper size is set to 30252 Address. But when the user opens the fresh copy of my database, the same report has a Paper size of 99015 Diskette. Other labels I have set for 4x6 paper on my copy come out 9X15 on the user's copy.” for our clarification?

    Note: Remove any private information before uploading the screenshots.

    @Tom, thanks for sharing the suggestions here.

    Best Regards,

    Cliff

    Was this answer helpful?

    0 comments No comments
  5. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2019-11-22T04:27:47+00:00

    My first guess is that the printer drivers on the various workstations are not identical.

    Was this answer helpful?

    0 comments No comments