Microsoft KB Archive/888696

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

Article ID: 888696

Article Last Modified on 6/18/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-





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 &quot;X.&quot;



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:  Use the Report Wizard to create a report that is based on the Northwind Products table. Use the ProductName field and the Discontinued field. In Design view, add a TextBox control to the Detail section. Right-click TextBox, and then click Properties. 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. Click the Data tab. For Control Source, type =IIF([Discontinued]=-1,&quot;Alt+0252&quot;)

Note &quot;ALT+0252&quot; 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 &quot;ü&quot; in the IIF statement.

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

The check mark appears without a border when the stock is discontinued.</li></ol>

Additional query words: check box check mark form ACC2007

Keywords: kbfunctions kbreport kbhowto KB888696

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.