Publish Microsoft Access check box controls to a Word document

Publish Microsoft Access check box controls to a Word document

Summary: When you publish an Access report to Word, you'll lose any check boxes the report contains. Luckily, you can take advantage of a couple of workarounds: Either display the literal values or use Wingdings to display the check box controls in Word. Here's a rundown of both tricks.

SHARE:

 |  Image 1 of 8

  • Thumbnail 1
  • Thumbnail 2
  • Thumbnail 3
  • Thumbnail 4
  • Thumbnail 5
  • Thumbnail 6
  • Thumbnail 7
  • Thumbnail 8
  • Access' native controls are functional without being overwhelming. However, the other Office applications don't always interpret Access controls properly. For instance, the publishing process loses check box controls and their bound data when publishing an Access report to Word. Fortunately, there are a couple of easy fixes for this limitation: Display the literal values or use Wingdings to display the check box controls in Word.

    This gallery is also available as an article and a PDF download.
  • By default, Access displays a check box control for a Yes/No field. A simple report, like this one, uses a check box to display the Discontinued values. We based this report on the Products table in the Access sample database, Northwind.

Topics: Data Centers, Collaboration, Data Management, Enterprise Software, Microsoft, Software

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

0 comments
Log in or register to start the discussion