Access SIG - Wed April 21st at 6:30 pm Regnier 2nd Floor

Presentation 1: Lisa Friedrichsen of Johnson County Community College
The two personalities of combo boxes.
Combo boxes are popular form controls. Users love them because they facilitate fast and accurate data entry.
However, combo boxes can be used to either enter data or find data. In this presentation we'll create combo boxes for both purposes, and uncover the properties that govern each.

Presentation 2: Bill Diamond of CFCA, Christian Foundation for Children & Aging
When printing labels in Access we have a couple of problems. The one we all face is what to do with the sheet of partially printed labels. Add it to the collection or go through a Sherlock Holmes analysis to figure just how many labels we need for the last sheet and search through our collection to find one meeting our needs or at least close. What if we could pull any sheet from this collection and use it as our first sheet. This limits our collection to only one sheet from now on. Next we have a problem from time to time of getting more information on the label than it appears it can hold. We will show a technique whereby we can squeeze space to add more lines to our label by tricking Access into doing what it is not supposed to do. The code and procedures necessary will be given out after the presentation.