Share via

Printing a query in Access

Andrea Vironda 816 Reputation points
2020-11-02T06:48:09.387+00:00

Hi,
I wish to print a pdf of my query but I notice I can't adapt column width.
How can I perform this operation?
36755-image.png

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,123 questions
0 comments
Accepted answer
  1. Erin Ding-MSFT 4,461 Reputation points
    2020-11-02T09:17:50.93+00:00

    @Andrea Vironda

    37310-image.png

    Thank you for reminding me, I see you modified the title.

    Maybe you could try as below before printing.

    1. Select the column or columns that you want to change.
    2. Click the Field Width from the drop-down menu of More in Records, then click Best Fit.
      37368-111.png
      37455-222.png

    Note: To quickly adjust the column width automatically, double-click the Select All button (screenshot as below).
    37416-333.png

    Besides, you could try to create a report and then

    1. In the Navigation Pane, right-click the report and then click Print Preview.
    2. On the Print Preview tab, in the Page Layout group, click Page Setup and set the column settings that you want.
      37406-444.png

    More information, you could refer to “Set print options in Access” and “Introduction to reports in Access”.

    Regards,
    Erin

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andrea Vironda 816 Reputation points
    2020-11-02T12:28:22.37+00:00

    Hi, we're speaking about Access, not Excel

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.