Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Software

Publish Microsoft Access check box controls to a Word document

By Susan Harkins April 11, 2007, 7:24 AM PDT

Image
1
of 8

access_checkbox_extra.jpg
access_checkbox_extra.jpg
Publish Microsoft Access check box controls to a Word document

Publish Access check box controls to a Word document

Publish Access check box controls to a Word document

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.

Publish Microsoft Access check box controls to a Word document

Check box controls in Access

Check box controls in Access

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.

Publish Microsoft Access check box controls to a Word document

Missing check boxes in Word

Missing check boxes in Word

Here’s what happens when you publish this report to Word. (To publish a report to Word, use the Office Links button.) The check box control and data completely disappears. To fix the problem, we can either display just the data in the form of Yes and No, On and Off, and True and False or use Wingdings to display the check box graphic.

Publish Microsoft Access check box controls to a Word document

Choosing the Text Box option

Choosing the Text Box option

The simplest way to guarantee that Yes/No values make it to Word is to display those values in a text box instead of the field’s default check box. The switch is simple. First, open the table with the Yes/No field in Design view and select the appropriate field row. Then, click the Lookup tab in the Properties panel and choose Text Box from the Display Control field, as shown here. Now, save the table and close it.

Publish Microsoft Access check box controls to a Word document

Displaying values instead of controls

Displaying values instead of controls

New reports based on the table will now display values, not check box controls.

Publish Microsoft Access check box controls to a Word document

Word displaying the Yes/No values

Word displaying the Yes/No values

When you publish the modified report, Word displays Yes and No values accordingly.

Publish Microsoft Access check box controls to a Word document

The Wingdings approach

The Wingdings approach

If you really want the check box controls in your Word document, you can have them. The first step is to replace the report’s check box with a text box, just as you did in the previous technique. It doesn’t matter whether you change the Display Control property at the table level or you replace the existing check box with a text box in the report.

Once you have a text box in the report, you must trick Word into displaying check box controls instead of values by setting the text box control’s Format property as follows:

  1. If you manually replaced the control, be sure to set the new text box control’s Control Source to the appropriate Yes/No field.
  2. Set the Font Name property to Wingdings.
  3. Select the control’s Format property, which will probably display Yes/No.
  4. The first format component determines how Access displays a false value (0). In the case of a Yes/No field, you want Access to display an empty check box. To enter the appropriate wingding character, hold down the [Alt] key and type 0168 on the numeric keypad — this value represents the empty check box character (for false value).
  5. Enter a semicolon character (;), which Access requires between formatting components.
  6. Enter a backslash character, which indicates that the character that follows is a literal character.
  7. To enter the Wingdings value for a checked check box (representing true values), hold down the [Alt] key and type 0254. As you can see here, you won’t be able to recognize the characters in the Property field.
  8. Save the report and display in Print View.
Publish Microsoft Access check box controls to a Word document

Displaying check boxes in Word

Displaying check boxes in Word

When you publish this report, Word has no problem displaying the checked and unchecked check box controls. If the controls are too small, simply adjust the control’s Font Size property in Access. (To learn more about formatting values via a control, search on “control formats” in Help.)

  • Software
  • Account Information

    Share with Your Friends

    Publish Microsoft Access check box controls to a Word document

    Your email has been sent

Share: Publish Microsoft Access check box controls to a Word document
Image of Susan Harkins
By Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
  • Account Information

    Contact Susan Harkins

    Your message has been sent

  • |
  • See all of Susan's content

TechRepublic Premium

  • TechRepublic Premium

    OneDrive Cloud Usage Policy

    This OneDrive Cloud Usage Policy, courtesy of TechRepublic Premium, defines the practices and behaviors organization representatives must follow when using any Microsoft OneDrive cloud file storage account to execute organization services, process organization data, or access or store organization information. From the policy: No organization representative should ever install a personal OneDrive account on any ...

    Downloads
    Published:  October 1, 2023, 4:00 PM EDT Modified:  October 2, 2023, 9:00 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Hiring Kit: Video Game Designer

    One of the most common and most requested jobs listed by the video game industry is the job of video game designer. Depending on the company, the platform, the project and the company’s specific development process, the job of a video game designer can mean many different things. But at its base level, a game ...

    Published:  October 1, 2023, 4:00 PM EDT Modified:  October 2, 2023, 9:00 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Environmental Policy

    For businesses, sustainability means maintaining the ecological, economic and holistic well-being of present and future clients. This entails taking into account the demands and necessities of individuals and society without jeopardizing the growth or wellness of the generations that follow. As an accountable business entity, this policy from TechRepublic Premium defines the company’s commitment to ...

    Downloads
    Published:  October 1, 2023, 4:00 PM EDT Modified:  October 2, 2023, 8:58 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Best of Confluent Current 2023: The State of Data Streaming

    TechRepublic Premium was at Confluent’s Current 2023 event, held in San Jose, California, September 26-27. Our coverage of the event comprises an analysis of data streaming, interviews, the role of stream governance and a look at Apache Flink. From the download: Confluent used the Current 2023 ‘next generation of Kafka Summit’ event in San Jose ...

    Downloads
    Published:  September 27, 2023, 4:00 PM EDT Modified:  September 28, 2023, 1:00 PM EDT Read More See more TechRepublic Premium articles

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice