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?
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
I guess I will just change the color permenantly
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.)
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.)
I'm having the opposite problem, I can't seem to print the backgound color!!
How did yoiu do it?
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: - Private Sub Command5_Click()
-
On Error GoTo Err_Command5_Click
-
-
'Assign the current background colors to variables
-
-
HeaderDefColor = Me.FormHeader.BackColor
-
DetailDefColor = Me.Detail.BackColor
-
FooterDefColor = Me.FormFooter.BackColor
-
-
'Change color to white
-
Me.FormHeader.BackColor = vbWhite
-
Me.Detail.BackColor = vbWhite
-
Me.FormFooter.BackColor = vbWhite
-
-
'Print the record
-
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
-
DoCmd.PrintOut acSelection
-
-
'Change the background color back to the original color
-
Me.FormHeader.BackColor = HeaderDefColor
-
Me.Detail.BackColor = DetailDefColor
-
Me.FormFooter.BackColor = FooterDefColor
-
-
Exit_Command5_Click:
-
Exit Sub
-
Err_Command5_Click:
-
MsgBox Err.Description
-
Resume Exit_Command5_Click
-
End Sub
Sign in to post your reply or Sign up for a free account.
Similar topics |
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
|
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
|
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
|
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.
|
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...
| |
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...
|
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
|
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.
|
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...
|
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...
|
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,...
| |
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...
|
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...
|
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
| |