pvs
New member
- Local time
- Today, 14:18
- Joined
- Sep 20, 2007
- Messages
- 7
I don't really think this is an Access issue, but maybe more of a printer problem ... but maybe somebody here has run across it before, and can point me in the direction of a solution.
I've built a report that contains three sets of similar columns, all formatted the same way, and showing similar data. The report prints correctly on my HP Inkjet at home, as well as two HP Lasers (one color, one B&W) here at work. But today, after installing the MDB file on two remote workstations (both of which share another HP laser) on my job, I found that in one column, SOME rows of the report are concatenating two of the columns. The affected rows of data are always the same (this is reproducible), and it is always the same column that fails to obey it's defined location (the other two sets of columns print correctly).
I have attached two photos of this report ... the first one is from a printer that is printing correctly, and the other shows the issue I am describing. From these samples, it MIGHT appear that fractional values in the column might be the problem, as the 100% ones on this page are correctly spaced, while all the non-100% ones are not, but this is not the case, as other pages DO have values under 100%, and with fractional amount correctly formatted.
FWIW, print preview on these two workstations is showing the data correctly formatted.
Oh ... and the yellow highlighting is just for illustrative purposes in this forum. It was added to the JPG images with photoshop, and is NOT done in Access ... just in case anyone thinks that the highlighting might be causing the issue.
Does anyone have any ideas? Could it be that the printer requires service? (It seems to work fine, otherwise). Colud this be being caused by a printer driver problem? Is there some way I can fix it within the Access Report?
Thanks in advance for any ideas anyone can come up with,
-pvs
I've built a report that contains three sets of similar columns, all formatted the same way, and showing similar data. The report prints correctly on my HP Inkjet at home, as well as two HP Lasers (one color, one B&W) here at work. But today, after installing the MDB file on two remote workstations (both of which share another HP laser) on my job, I found that in one column, SOME rows of the report are concatenating two of the columns. The affected rows of data are always the same (this is reproducible), and it is always the same column that fails to obey it's defined location (the other two sets of columns print correctly).
I have attached two photos of this report ... the first one is from a printer that is printing correctly, and the other shows the issue I am describing. From these samples, it MIGHT appear that fractional values in the column might be the problem, as the 100% ones on this page are correctly spaced, while all the non-100% ones are not, but this is not the case, as other pages DO have values under 100%, and with fractional amount correctly formatted.
FWIW, print preview on these two workstations is showing the data correctly formatted.
Oh ... and the yellow highlighting is just for illustrative purposes in this forum. It was added to the JPG images with photoshop, and is NOT done in Access ... just in case anyone thinks that the highlighting might be causing the issue.
Does anyone have any ideas? Could it be that the printer requires service? (It seems to work fine, otherwise). Colud this be being caused by a printer driver problem? Is there some way I can fix it within the Access Report?
Thanks in advance for any ideas anyone can come up with,
-pvs
Attachments
Last edited: