Book

Suggestions


Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Friday, July 11, 2008 – Permalink –

Checkmark vs. Checkbox

Just the check


Use of a Boolean Yes/No checkbox is pretty common.

Here is a way to place just a checkmark next to an entry.
Not Channel 9 material, but good to know.

Display ü

  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.


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



See all Topics

Labels: , ,


<Doug Klippert@ 3:13 AM

Comments: Post a Comment