IT Employment

Ask something
Discussion Locked

Access 2K Report Layouts

0 helpful
3 replies

by cnwoods

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I've got a project completed in Access 2000, and had problems with the reports (mostly landscape) resetting until I deselected the name autocorrect functions. Thing is, that only fixes it on my machine, and this database has to be propagated over anetwork (using replication manager). Is there any way to create a code that onOpen will reset the report page layout & margins so they will work uniformly? (or any way to embed the formatting into the report so it goes out with the database...)Thanks in advance for any & all answers - need this one fairly quickly, please!

3 replies

by haris

You can open the reports in design view and can change the layout of the reports, including the paper size, layout and oientation. You can also place the PAGE SETUP tool bar on your access project. This will allow the users to format the reports to their requirements. Access has an option that allows PREVIEWING the reports before sending them to print. You can use this option and enable the PAGE SETUP tool bar.

by cnwoods

Please read the question a bit more carefully next time. I wanted to PREVENT users from being able to customise reports, and embed a standard layout that everyone would use without having to get everyone to go through those processes you listed, orgoing through them ourselves on every copy of the database we distributed.

This discussion is closed to new replies.