How to convert a form into a report in Access?

Forms are designed for data entry reports for data display. It would not make much sense to convert a form to a report.

You are better off, creating a query that contains the data you want and using the Report wizard to create and layout the report the way you want it.

The main difference between the layout of a form and report in Access is that the latter allows data to be grouped.  You might have a query for instance which returns all orders made by customers.  Such a query would return multiple instances of each customer's data from a Customers table, similarly multiple instances of data from an Orders table, and single instances of each product ordered per order per customer from an OrderDetails table. 

In a report you would group the report firstly by CustomerID or similar, secondly by OrderID or similar.  The customer data and each order data, e.g. the order number and order date, would be returned only once in the respective Group Header sections in the report.  The products ordered would be returned in the report's Detail section. 

Without knowing the how your data is stored in related tables it is difficult to say for certain what would be the RecordSource of a report, but the image you have posted suggests the report layout would be a very simple one, without any grouping.  All of the data would therefore be returned in the detail section, so you need to build a query which returns all of the columns (fields) from whatever tables are necessary.  In report design view you'd then lay out the controls bound to the columns from the query, along with their relevant labels, in the report's Detail section. 

When it comes to including an image in the report the best way to do this is not to store the image itself in the database, but to store the path to an external image file in a text column in the Properties table or similar. In the report include an Image control an set its ControlSource property to the name of the text column. 

For examples of how to display an image with each record in the report take a look at Images.zip in my Dropbox public databases folder at: 

https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0 

In the zip archive the Images_Simple.accdb file would be a suitable model for your requirements.  This enables images to be added by browsing to an image file via a button on the frmAddresses form.  It is best to use image files of .png file type, and the image files should be of a resolution no greater than that necessary for the purposes of the database.  Image files of very high resolution will be slower to load at runtime.

Copilot answer.

If the above isn't what you want, then ask your question to Copilot.

This doesn’t make much sense without some context. Do you have more than one site photo for a property? Are you storing the location of the photos? Do you want the photo to change when the property record changes? Edit, I just reread the title/subject and I’m maybe more confused.

Hi @Kacee Miller

Thank you for reaching out to Microsoft Q&A Forum! 

Please understand that our forum is a public platform, and we will modify your question to remove any your personal or organizational details in the screenshot. Please notice to hide these personal or organization information next time you post error or some information to protect personal data. 

It sounds like you're trying to convert a form into a report in Access. I’ve tested this on my end, and you might want to try the following steps: 

Click your Form > Go to the Create tab. 

• In the Reports group > click Report Wizard.
• Follow the instructions in the wizard. On the final page, click Finish.

For more details, you might find these articles helpful: 

Create a query, form, or report in Access - Microsoft Support 

Create a simple report - Microsoft Support 

I hope this helps! If I misunderstood your question, please feel free to correct me. I'm happy to help further.

If the answer is partially helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".    

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.