Convert Form to Report (Access2007) (1 Viewer)

Hi there,

I have spent some time developing a form which acts as a kind of live dashboard of data (taking information from a variety of tables as they are updated)

But now I need to be able to print it in the same format as I've designed it and it appears printing forms is not something which is inherently simple in Access!

So it looks like I have to recreate the form as a report and then use that for printing. Is there a quick & easy way of doing this (the layout of the form is exactly the way I'd like the report to look) without having to go through a rigorous design process?

There is another thread on here which suggests that it's possible to simply save a form as a report but I can't figure out where this might be done? I don't have an option to 'Save As...' in either the Navigation Pane or within the VBE.

How would one do this? (in AC2007)

Thanks!

AOB

With the form open in design view, click the Office button then Save As.

pbaldy,

Apologies for the delay - this is great, thanks!

AOB

Happy to help!