Access does not print color - sometimes

[JohnPapa]

In some installations of our software (dental package) Access 03 does not print color, but prints black and white.

This must be not be a problem with Access 03, but I have not been able to find the problem.

Any ideas?
John

 

[vbaInet]

Ask this question in the Hardware section of the forum. This is a printer related issue.

 

[JohnPapa]

Dear vbaInet, I have posted on Hardware section as well, but after some further research the problem may relate to software.

Other people have experienced similar problems. A report would print in color only after it was previewed, but printed in B&W if printed directly from code.
John

 

[vbaInet]

What code are you using? Have you tried opening the report before printing?

 

[JohnPapa]

I am using Access 03 and one of the commands which sometimes results in B&W instead of color is

DoCmd.OpenReport "rptName"

I usually include additional parameters in the command, but for some reason I did not include these parameters this time.

I am investigating right now (at a site with a problem) whether previewing would solve the problem.

John

 

[DCrake]

It could be to do with printer preferences on the actual printer setup. It may be defaulting to printing black/white or gayscale. Set it to colour and se if that resolves it.

 

[JohnPapa]

Hi DCrake,
On a specific printer exhibiting the problem (ie B&W instead of color) when we printed a .jpg file it printed it in color and according to the owner of the printer, it always prints color except the Access report. I am waiting to hear from the priner owner whether the specific report would print in color if first previewed.
John

 

[DCrake]

If you still have issues how about outputting the report as a pdf then printing the pdf. Have you tried it in other versions of Access?

 

[JohnPapa]

I only tried in Access 03, hence cannot output to .pdf. I output to .snp.
John

 

[JohnPapa]

Clarification, I output to .snp when I email the report.
John

 

[Simon_MT]

What sort of printers are involved. I know that some of the inkjet printers have settings to print whichever shade of grey you like! i.e. Black and White. I'm just trying to think what is going on, a colour is made up of Red Green Blue. At one end of the scale:

black: r=255 g=255 b=255

and the other

white: r=0 g=0 b=0.

As you can see the colour profile for even black or white is quite specific so it would seem for some reason the colours have been forced into greyscale. I have printed thousands of jpegs admitted to [FONT=&quot]di-sublimation[/FONT] printers and then to Xerox Phaser printers. The only difference with jpegs compared with a bit map is whilst it is lossy jpegs do have the ability to handle large blocks of the same colour and therefore more efficient but this should not affect the loss of colour completely.

You could do an audit of the drivers and the colour profiles and printer properties to see if they are correct.

Simon

 

[JohnPapa]

Simon-MT thanks for your input,

The problem of color pictures printing in greyscale occurs in two installations. I did some reserach and experimentation on one of the installations and we got it to print in color by first setting the printer preference Grayscale to true and then setting it to false. After this toggle the printer printed in color.

I will try the same on the other installation.

If it would be useful to get the actual printer specs, I can provide.

John

 

[vbaInet]

Good to know you're making progress...

 

[brucesckwack]

Hey John Papa please provide me the printer specs because even i have the same problem.

 

[JohnPapa]

Hi brucesckwack,
One of the printers that prints in B&W is the Canon NX850 (ink-jet)