MIE Software Support Note
Subject: |
Workaround for "Some data may not be displayed. There is not enough horizontal space on the page for the number of columns and spacing you specified." message when producing address labels (and/or name badges in Summit Pro 2000). Workaround for system crashing when previewing name badges. |
| Applies To: | All Products |
| Date: | 16 March 2000 |
The message "Some data may not be displayed. There is not enough horizontal space on the page for the number of columns and spacing you specified." may be displayed if you are producing address labels or name badges using stationery with no margin or a very small margin. This is because Microsoft Access 97 does not recognise a zero margin any longer and looks at your printer's unprintable area to determine if the labels/badges can fit on the page. As the unprintable area varies from printer to printer this message may appear with some printers, but not with others.
When you press OK, Access may also crash if any part of your name badge or ticket is within your printer's unprintable area. There are three ways of dealing with this problem.
1. Change stationery.
Change to a name badge or address label stationery with wider margins around the border of each page. If the width of the margins is greater than your printer's unprintable area the message will no longer be displayed.
2. Reduce the setting of your printer's unprintable areas.
Some printers, such as the HP Laserjet IIP Plus, allow you to override the default settings for the unprintable area. In the HP Laserjet IIP Plus example, click Start, then Settings, then Printers and right-mouse click on the HP Laserjet IIP Plus and then select properties as shown below.
From properties, select the Paper tab, and then click on Unprintable Area and reduce the unprintable settings as shown below.
Note that not all printers allow you to modify the unprintable area settings.
3. Export the name badge information to a text file and produce the badges using Mail Merge Address labels in Microsoft Word. the formatting of your original name badges will not be used, but the data will be there. To do this take the following steps.
On the name badges and tickets screen select Export instead of Preview.
After the data has been exported start Microsoft Word.
Select Tools, then Mail Merge to display the Mail Merge Helper.
Click the Create button and select Mailing Labels.
Click Get Data and then select Open Data Source and then specify the text file you created with the export as the data source to use.
When you return to Summit, click that the badges were produced successfully so that those peoples' records will be marked as having had their name badge produced.