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


INTRODUCTION


You can use the CheckBox control in a Microsoft Office 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 Discontinuedfield.
  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.