Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
Resources
  • TechRepublic Premium
  • TechRepublic Academy
  • Newsletters
  • Resource Library
  • Forums
  • Sponsored
Go Premium
Popular Topics
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
  • Project Management
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
View All Topics
Go Premium
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

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic TechRepublic
  • TechRepublic on Facebook
  • TechRepublic on X
  • TechRepublic on LinkedIn
  • TechRepublic on YouTube
  • TechRepublic on Pinterest
  • TechRepublic RSS
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
  • Editorial Policy
  • Legal Terms
  • Privacy Policy
© 2025 TechnologyAdvice. All rights reserved.
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

Back to Home Page
×