Just the check

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,
   
   
   1. In the TextBox properties dialog box, click the Format tab. For Border Style, click Transparent. For Font Name, click Arial.
      
      
   2. Click the Data tab.
      
      
   3. For Control Source, type =IIF([Discontinued]=-1,"X")
      
7. Close Design view.
   
   
8. Click Preview.

Labels: General, Reference, Shortcuts, Tips, Tutorials