473,699 Members | 2,506 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Get access not to print background color of Form

emandel
65 New Member
The background of my form is dark blue,
Is there any way to tell access that when printing it should not print the background or it should change the background?
Jan 1 '07 #1
6 7399
MMcCarthy
14,534 Recognized Expert Moderator MVP
The background of my form is dark blue,
Is there any way to tell access that when printing it should not print the background or it should change the background?
At a guess I would say no because Access prints a snapshop. You could always change the background colour before printing and change it back afterwards I suppose.

Mary
Jan 1 '07 #2
emandel
65 New Member
I guess I will just change the color permenantly
Jan 2 '07 #3
Killer42
8,435 Recognized Expert Expert
I guess I will just change the color permenantly
Don't give up too quickly. You shouldn't have to compromise your user interface to accommodate printing. Mmccarthy's suggestion should help, and it's not complicated. Well, to be honest, that probably depends on how the printing is initiated.

I would imagine there are numerous ways to resolve your problem, some more complex than others. For excample, you could create a print-only version of the form which is never displayed on-screen. You might evcen do this temporarily at run-time.

Anyway my point is, don't be discouraged just because you can't do it quite as easily as you'd hoped. Look at it as a learning experience. (Besides, it may be as simple as adding two more statements.)
Jan 2 '07 #4
Killer42
8,435 Recognized Expert Expert
Something just came to mind. Keep in mind I'm not expert in this area, but couldn't you do something like using an image for the background (I'm not sure how you'd get it to look right), and set the DisplayWhen property for that image to screen only?

(Hope you saw my earlier message.)
Jan 2 '07 #5
robertoathome
20 New Member
I'm having the opposite problem, I can't seem to print the backgound color!!
How did yoiu do it?
Apr 4 '07 #6
missinglinq
3,532 Recognized Expert Specialist
Mary's idea is very simple to implement. If you use the Command Button Wizard to generate a Print Record button, simply modify the code like this:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Command5_Click()
  2. On Error GoTo Err_Command5_Click
  3.  
  4.   'Assign the current  background colors to variables
  5.  
  6.   HeaderDefColor = Me.FormHeader.BackColor 
  7.   DetailDefColor = Me.Detail.BackColor
  8.   FooterDefColor = Me.FormFooter.BackColor
  9.  
  10.    'Change color to white
  11.    Me.FormHeader.BackColor = vbWhite 
  12.    Me.Detail.BackColor = vbWhite 
  13.    Me.FormFooter.BackColor = vbWhite
  14.  
  15.    'Print the record
  16.    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
  17.    DoCmd.PrintOut acSelection
  18.  
  19.    'Change the background color back to the original color
  20.    Me.FormHeader.BackColor =  HeaderDefColor
  21.    Me.Detail.BackColor = DetailDefColor  
  22.    Me.FormFooter.BackColor = FooterDefColor 
  23.  
  24. Exit_Command5_Click:
  25.     Exit Sub
  26. Err_Command5_Click:
  27.     MsgBox Err.Description
  28.     Resume Exit_Command5_Click
  29. End Sub
Apr 4 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

3
5929
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be terminated by pressing ++ and then terminate the process. I searched the entire internet and found out that there could be two things wrong (both of them are mentioned in the bug list on the access
7
14365
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to display the graph but it is not possible to send query parameters to an OLE graph on a report (or programatically change any properties of an OLE Graph). However with a Form you do have the ability to change the RowSource of
2
20737
by: Michelle Marie | last post by:
I have several forms stored in pdf format. Instead of scanning these forms and using them in reports, I would like to create a background in an access report to place the fields but have it actually print out onto the pdf form file. The form loses resolution if scanned and used in an access report. Thank you in advance for your help. Michelle Marie
0
5380
by: ghadley_00 | last post by:
MS Access Create form / report with multiple pages using different background images Hi, Would like to have users fill out a multipage form, and then click a print button, which pulls up the info just entered for a particular record and print out multiple pages of forms, each page having a different image as background.
6
1577
by: Thelma Lubkin | last post by:
I tried to ask this a few days ago: I was then thinking in terms of using a parameter query--I've since decided that that was not a good approach. I have a form that displays information on 'colorsets': setname, number of colors (limited to >=3, <=11) in set, settype. The form displays this for one set at a time, but the user can scroll through all the available colorsets. The form is in a one-to-many relationship with a subform that...
0
2015
by: John | last post by:
I have a class that creates an AxWebBrowser object in the background, loads some arbitrary html content, then shows the user a print preview. The only problem is, this print preview is a tiny little window on the top left hand corner of the screen. Thinking that this may have something to do with the Print Preview dialog not being able to detect from it's caller's size so that it can set its own size equal to that of the caller, I...
2
14119
by: Dean Slindee | last post by:
Anybody written code in VB.NET to: 1) show a print preview window of reports already written and stored in an Access 2002 database; or 2) execute the print of a report stored in an Access 2002 database? Thanks, Dean Slindee
4
3520
by: JBiggsCC | last post by:
I have a very simple login page which takes an ID number via a HTML form GET. What is easiest way to check that ID number against an Access DB to see if it exists? I want to redirect with the ID in the query string if it does exist and have them re-enter if incorrect.
2
2101
by: dmorand | last post by:
When I try to print a 'print version' of my page it looks fine in IE 7, but when I print in IE 6 the margins are all screwed up. The page itself looks the same in both browsers, it's just when I print the elements look bigger when I print from IE 6 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta...
0
9033
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8911
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
8882
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7748
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6533
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5872
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4375
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4627
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3057
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.