473,587 Members | 2,547 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

printing in all black when report has some color

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.c om
http://www.accessmonster.com/Uwe/For...ccess/200603/1
Mar 27 '06 #1
5 5466
"ka******@comca st.net via AccessMonster.c om" <u15580@uwe> wrote in
news:5de46fe25b 6fa@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
Mar 27 '06 #2
ka******@comcas t.net via AccessMonster.c om 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, programmaticall y turn off your conditional formatting.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Mar 27 '06 #3
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 programmaticall y 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, programmaticall y turn off your conditional formatting.


--
Greg

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200603/1
Mar 28 '06 #4
ka******@comcas t.net via AccessMonster.c om 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 programmaticall y 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, programmaticall y turn off your conditional formatting.


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

Me!tbxText1.For matConditions.E nabled = False

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Mar 28 '06 #5
good idea but it didn't work. i had this as my code:

Private Sub Detail_Print(Ca ncel As Integer, PrintCount As Integer)
Me.txtboxstockn umber.FormatCon ditions(1).Fore Color = RGB(0, 0, 0)
Me.txtboxstockn umber.FormatCon ditions(2).Fore Color = RGB(0, 0, 0)
Me.txtboxstockn umber.FormatCon ditions(3).Fore Color = 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, programmaticall y turn off your conditional formatting.


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

Me!tbxText1.Fo rmatConditions. Enabled = False


--
Greg

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200603/1
Mar 29 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3893
by: Xiphias | last post by:
Hi, Im trying to change the color of a text box on a report that im printing from a form. On the form I got a check box that has to tricker the color of that textbox on the printed report. If checked color is red else just black. But I dont know how to do it.
4
9218
by: Arif | last post by:
I C# code prints very slow as compared to a third party barcode printing software. That software prints approximately 10 labels in 2 seconds while my C# code prints 10 labels in 5 to 6 seconds. And this differences increases with the increase number of labels. The code is as follwods: Here rdr = OleDbDataReader Font is Times New Roman, 12pt
0
1819
by: Nigel | last post by:
I successfully create a .NET Component (Visual Basic .NET) that would print, unfortunately when used within a web browser it appears that .NET security doesn't allow you to run code that interacts with the file system (including printing) from the web browser. How do I disabled this so I can get my windows form control to work within IE? ...
0
1479
by: Nigel | last post by:
The Visual Basic .NET Step by Step book has the following code and text: Imports System.Drawing.Printing Private Sub PrintText(ByVal sender As Object, ByVal ev As PrintPageEventArgs) ev.Graphics.DrawString(TextBox1.Text, New Font("Arial", 11, FontStyle.Regular), Brushes.Black, 120, 120) ev.HasMorePages = False End Sub
1
5077
by: Dreamtime | last post by:
Hi I am using Visual Studio 2005 and the bundled Crystal Reports (previously I used .net 2003 and bundled Crystal Reports for 2 years - same issues!) I have a report which is displayed in the crystal reports viewer. This report needs to be printed. Its that simple! I would like to use the report.printtoprinter method as this is direct
6
4080
by: Siv | last post by:
Hi, I am getting into printing with VB.NET 2005 and want to implement the usual capability that a user can select a selection of pages. I have a report that is generated by my application that if the user wants all pages will produce 3 pages. I want to offer the user the ability to select via the print dialog that only pages 1 and 2 of it...
3
2168
by: Wayne | last post by:
I'm reasonably sure that this issue isn't related to the database as such. I have an Access 2003 report with a couple of coloured logos on it that was printing fine, but now the logos only print in black and white. They display OK on screen and other coloured documents from MS Word etc can be printed OK to the printer in question. If the...
2
9951
by: Brad Pears | last post by:
I have a vb.net 2005 application and am using the print preview screen. This screen has a printer icon on it that the user can use to print the document currently being viewed. It uses the default printer settings to print. I wanted the print preview to appear the same for all users (i.e. a default page size of 8.5x14 (legal) and portrait...
3
5046
by: =?Utf-8?B?QnJpYW4gQ29vaw==?= | last post by:
Is there a way to force printing in black and white programatically?
0
7920
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7849
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8215
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8347
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7973
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5718
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3844
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2358
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.