How to print a check box without borders on a pre-printed form in Access (888696)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Access 2000

INTRODUCTION

You can use the CheckBox control in a Microsoft Access form or in an Access report. However, you do not have an option to change the display properties that appear on the form or on the report. For example, you do not have an option to display the check box as a check mark without a border or to display the check mark as an "X."

MORE INFORMATION

You can print a check in the preprinted CheckBox control in a form or in a report without printing the check box border. This lets you control the size of the check mark.

You can use a formula to let you display the check mark or not display the check mark. To do this, follow these steps:
  1. Use the Report Wizard to create a report that is based on the Northwind Products table. Use the ProductName field and the Discontinued field.
  2. In Design view, add a TextBox control to the Detail section.
  3. Right-click TextBox, and then click Properties.
  4. In the TextBox properties dialog box, click the Format tab. For Border Style, click Transparent. For Font Name, click Wingdings.

    Note You can adjust the size of the check mark by changing Font Size.
  5. Click the Data tab.
  6. For Control Source, type =IIF([Discontinued]=-1,"Alt+0252")

    Note "ALT+0252" is the check mark character. To enter this character, hold down ALT, and then type 0252 by using the keypad. The check mark character appears as "ü" in the IIF statement.

    Note If you want to display an "X" instead of a check mark, follow these steps:
    1. Right-click TextBox, and then click Properties.
    2. In the TextBox properties dialog box, click the Format tab. For Border Style, click Transparent. For Font Name, click Arial.
    3. Click the Data tab.
    4. For Control Source, type =IIF([Discontinued]=-1,"X")
  7. Close Design view.
  8. Click Preview.

    The check mark appears without a border when the stock is discontinued.
Modification Type:MajorLast Reviewed:12/21/2004
Keywords:kbfunctions kbReport kbhowto KB888696 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.