maryannrichardson

Here’s a lightning-fast way to globally replace styles in a Word document.

Don’t let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes.

Changes to an Access record aren’t saved until the user moves to the next record — which can sometimes mean tabbing through a bunch of controls just to execute the save. See how to add a Save Record button that lets the user save a record immediately after a change.

Want to make sure users don’t accidentally send hundreds of copies of a form to the printer? Just add a button to the form that will ensure the form is printed only for the current record.

Hyperlinks in a Word document offer a convenient way to jump out to the Web. Make them even handier by setting them up to open in a separate window.

Ensuring that your Access report groups print out on individual pages is just a matter of tweaking your group header property settings. Mary Ann Richardson shows how to do it.

If all your document footer needs are page numbers, try this quick field code approach to inserting them. You’ll save time and mouse clicks in the process.

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.

Margins can lead to extra blank pages in your Access report, potentially leading to waste and headaches. Here’s how to change the Page Setup to streamline your report into just the length you desire.

Control how your data records will display when a user opens a form in your Access application — Single Form, Continuous Forms, Datasheet, PivotTable, and more — by setting a default. Here’s how.

Moving a table in a Word document can be tricky. Here’s how to make Word move it into the right place for you. position it for you.

Office 2007 lets you convert your documents, spreadsheets, and PowerPoint presentations to PDF — optimized for online documents, printed documents, or both. But before you can convert your document to PDF format, says Mary Ann Richardson, follow these steps.