printing in all black when report has some color

[kaosyeti]

how can i get my report to print all in black when i have a control with
conditional formatting to change the font color about 10% of the time it
shows up. i've been trying to find a way to format the onprint event in the
detail section but i can only change the font size, bold/itialic, etc.. any
ideas?

--
Greg

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200603/1

[Lyle Fairfield]

"ka******@comcast.net via AccessMonster.com" <u15580@uwe> wrote in
news:5de46fe25b6fa@uwe:

how can i get my report to print all in black when i have a control
with conditional formatting to change the font color about 10% of the
time it shows up. i've been trying to find a way to format the
onprint event in the detail section but i can only change the font
size, bold/itialic, etc.. any ideas?

When I want black only I send the report to a black only printer. When I
want color I send it to a color printer. Has worked every time so far!

--
Lyle Fairfield

[Randy Harris]

ka******@comcast.net via AccessMonster.com wrote:

how can i get my report to print all in black when i have a control with
conditional formatting to change the font color about 10% of the time it
shows up. i've been trying to find a way to format the onprint event in the
detail section but i can only change the font size, bold/itialic, etc.. any
ideas?

Most printers have a setting in the driver that will permit black and
white print. Create another print queue that prints in black and white.

Or, if you prefer, programmatically turn off your conditional formatting.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[kaosyeti]

lyle's comment aside, the problem is that my black and white only printer is
printing the colored controls in shades of grey. this would be the same for
any driver settings or other printer-driven solutions that are possible. i
wanted a solution to turn my conditional formatting off programmatically for
the onprint event. any ideas how?

Randy Harris wrote:

how can i get my report to print all in black when i have a control with
conditional formatting to change the font color about 10% of the time it
shows up. i've been trying to find a way to format the onprint event in the
detail section but i can only change the font size, bold/itialic, etc.. any
ideas?

Most printers have a setting in the driver that will permit black and
white print. Create another print queue that prints in black and white.

Or, if you prefer, programmatically turn off your conditional formatting.

--
Greg

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200603/1

[Randy Harris]

ka******@comcast.net via AccessMonster.com wrote:

lyle's comment aside, the problem is that my black and white only printer is
printing the colored controls in shades of grey. this would be the same for
any driver settings or other printer-driven solutions that are possible. i
wanted a solution to turn my conditional formatting off programmatically for
the onprint event. any ideas how?

Randy Harris wrote:

how can i get my report to print all in black when i have a control with
conditional formatting to change the font color about 10% of the time it
shows up. i've been trying to find a way to format the onprint event in the
detail section but i can only change the font size, bold/itialic, etc.. any
ideas?

Most printers have a setting in the driver that will permit black and
white print. Create another print queue that prints in black and white.

Or, if you prefer, programmatically turn off your conditional formatting.

I haven't played with the exact syntax, but you should be able to use
something like:

Me!tbxText1.FormatConditions.Enabled = False

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[kaosyeti]

good idea but it didn't work. i had this as my code:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.txtboxstocknumber.FormatConditions(1).ForeColor = RGB(0, 0, 0)
Me.txtboxstocknumber.FormatConditions(2).ForeColor = RGB(0, 0, 0)
Me.txtboxstocknumber.FormatConditions(3).ForeColor = RGB(0, 0, 0)
End Sub

and i got an error that basically said that i can't set conditional formats
in print preview mode or once printing had started. any other direction you
can think to go in?

Randy Harris wrote:

lyle's comment aside, the problem is that my black and white only printer is
printing the colored controls in shades of grey. this would be the same for

[quoted text clipped - 11 lines]

Or, if you prefer, programmatically turn off your conditional formatting.

I haven't played with the exact syntax, but you should be able to use
something like:

Me!tbxText1.FormatConditions.Enabled = False

--
Greg

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200603/1