Print Preview of form

Using Access 2003 SP2
For new databases, the form details are not visible in print preview. The 
visibility of the details section is set to Visible (yes).  Any ideas why 
only the form detials is not visible in print preview and all other objects 
view properly?  It is only this database.  Databases created in early months 
view properly.  There are no updates on MS site to indicate an issue.
0
Utf
1/11/2008 10:47:00 PM
access.forms 6864 articles. 2 followers. Follow

5 Replies
1212 Views

Similar Articles

[PageSpeed] 38

On Jan 11, 5:47=A0pm, rebecca <rebe...@discussions.microsoft.com> wrote:
> Using Access 2003 SP2
> For new databases, the form details are not visible in print preview. The
> visibility of the details section is set to Visible (yes). =A0Any ideas wh=
y
> only the form detials is not visible in print preview and all other object=
s
> view properly? =A0It is only this database. =A0Databases created in early =
months
> view properly. =A0There are no updates on MS site to indicate an issue.

Somebody has set the "Display When" property of the detail section to
"Screen Only". Change it back to the default of "Always"

0
rquintal
1/12/2008 12:07:43 AM
=?Utf-8?B?cmViZWNjYQ==?= <rebecca@discussions.microsoft.com> wrote
in news:18E908F1-4D8D-49EA-B13F-CEFA36DF707C@microsoft.com: 

> Using Access 2003 SP2
> For new databases, the form details are not visible in print
> preview. The visibility of the details section is set to Visible
> (yes).  Any ideas why only the form detials is not visible in
> print preview and all other objects view properly?  It is only
> this database.  Databases created in early months view properly. 
> There are no updates on MS site to indicate an issue. 
> 
Somebody has set the "Display When" property of the detail section to 
"Screen Only". Change it back to the default of "Always"


-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com

0
Bob
1/12/2008 4:45:30 PM
Thank you fo ryour reply.  The form was visible in form view previously with 
Display When set to 'always'; however the form is NOT visible in PRINT 
Preview.  Do you happen to have another idea?

"rquintal@sympatico.ca" wrote:

> On Jan 11, 5:47 pm, rebecca <rebe...@discussions.microsoft.com> wrote:
> > Using Access 2003 SP2
> > For new databases, the form details are not visible in print preview. The
> > visibility of the details section is set to Visible (yes).  Any ideas why
> > only the form detials is not visible in print preview and all other objects
> > view properly?  It is only this database.  Databases created in early months
> > view properly.  There are no updates on MS site to indicate an issue.
> 
> Somebody has set the "Display When" property of the detail section to
> "Screen Only". Change it back to the default of "Always"
> 
> 
0
Utf
1/14/2008 4:50:08 PM
thank you for your earlier reply. The form is only not visible in Print 
Preview.  Details and form view look beautiful. Do you have another idea?

"Bob Quintal" wrote:

> =?Utf-8?B?cmViZWNjYQ==?= <rebecca@discussions.microsoft.com> wrote
> in news:18E908F1-4D8D-49EA-B13F-CEFA36DF707C@microsoft.com: 
> 
> > Using Access 2003 SP2
> > For new databases, the form details are not visible in print
> > preview. The visibility of the details section is set to Visible
> > (yes).  Any ideas why only the form detials is not visible in
> > print preview and all other objects view properly?  It is only
> > this database.  Databases created in early months view properly. 
> > There are no updates on MS site to indicate an issue. 
> > 
> Somebody has set the "Display When" property of the detail section to 
> "Screen Only". Change it back to the default of "Always"
> 
> 
> -- 
> Bob Quintal
> 
> PA is y I've altered my email address.
> 
> -- 
> Posted via a free Usenet account from http://www.teranews.com
> 
> 
0
Utf
1/14/2008 4:51:02 PM
=?Utf-8?B?cmViZWNjYQ==?= <rebecca@discussions.microsoft.com> wrote
in news:96F2E4B5-D131-4BBA-94AB-223CC4FD6684@microsoft.com: 

> Thank you fo ryour reply.  The form was visible in form view
> previously with Display When set to 'always'; however the form is
> NOT visible in PRINT Preview.  Do you happen to have another idea?
> 
You are contradicting what you said earlier, you said before "the 
form details are not visible", now you say " the form is not 
visible". Which is correct?

Please identify which statements are true.
The details section is visible in print preview.
The details section is visible when printed to paper.
The details section is visible but controls /1 are invisible in 
print preview.
The details section is visible but controls /1 are invisible when 
printed to paper.

/1 controls include textboxes, labels, command buttons, etc.

BTW, if the Display When on a form's section or a control is set to 
Screen Only, you will see the details in Form View, but it will be 
hidden in Print Preview and in print.

The only other possibility is some corruption of the database.

Q

> "rquintal@sympatico.ca" wrote:
> 
>> On Jan 11, 5:47 pm, rebecca <rebe...@discussions.microsoft.com>
>> wrote: 
>> > Using Access 2003 SP2
>> > For new databases, the form details are not visible in print
>> > preview. The visibility of the details section is set to
>> > Visible (yes).  Any ideas why only the form detials is not
>> > visible in print preview and all other objects view properly? 
>> > It is only this database.  Databases created in early months 
>> > view properly.  There are no updates on MS site to indicate an
>> > issue. 
>> 
>> Somebody has set the "Display When" property of the detail
>> section to "Screen Only". Change it back to the default of
>> "Always" 
>> 
>> 



-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com

0
Bob
1/14/2008 11:58:19 PM
Reply:

Similar Artilces:

Modifying Forms
Is there a way to relabel the label colors on the Appointment form? Do you mean to modify them or what? Modifying the label names is very easy. Right click on an appointment->Label->Edit Label. I presume you are using Outlook 2002 or 2003, correct? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Cindy MIkeworth asked: | Is there a way to relabel the label col...

Blank forms 01-06-10
Hi, I recently took over our Access 2003 Database from our guy that got laid off and I am a newbie++. I am having a problem with a form. I have a form then I have a subform embedded within that. When I log in with the developer account, I can see the form, but the area where the sub form is is greyed out. When I log in as a user and try to open the form, I have a completely blank window. When I am looged in as developer and look at the form in Design view can I can see all of the fields in the subform that are supposed to be there, but in Form view it magically becomes grey. I ha...

How to print priority mail label in excel
I will like tosetup and print address on the pre printed "Priority Mail" blank lable supplied by the post office. Use Excel as the datasource, setting up the mailmerge in Word -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "TROJAN" <TROJAN@discussions.microsoft.com> wrote in message news:5BF8F98A-1119-4506-92A3-12A1FF9FA431@microsoft.com... >I will like tosetup and print address on the pre printed "Priority Mail" > blank lable supplied by the post office. ...

Unable to print shades of gray
Hello everyone.... I'm trying to print out calendars that have certain days grayed in, (the cell for that day is filled with a shade of gray). My printer is working and will print black and white... with gray but won't in publisher or word. I have Office Professional 2003 with the latest upgrades. My OS is MS XP Pro... with SP2. Any help is appreciated, thanks Kristinmerri This will be a printer issue, do you have the latest driver for your printer? -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Kristinmerri" <kr...

Email printed mystery
I am totally confused how this happened, if anyone can clue me in i would really appreciate it. AD 2k3 mixed Exchange 2k3 I have a user, we will call him Mike, who was working at home via Outlook Web Access. At one point Mike's cat jumps up on the keyboard and lays down and a sensative company email from "Sally" to "Kate" and "Mindy" prints on his printer at home. Mike says he never had this email in his mailbox and never had it as an attachment either, nor on his desktop. Mike has never seen this email that just printed. I ran message tracking to...

All my 1099's aren't printing
I have printed my 1099's and now have vendors calling me that they never recieved one. The hard copy does not show that one was printed for these vendors, but the system does show me that one should have printed. Any ideas??? ...

Report that print quotes closed or quote status
How can I print a report that display the quotes status? I mean all quotes open (no invoices done) or quotes closed (quotes converted invoice) You can edit the quote summary report and add Begin Column FieldName = "[Order].Closed" DrillDownFieldName = "" DrillDownReportName = "" Title = "Closed" VBDataType = vbBoolean Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1005 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignCenterCente...

Fill-In Form Problem
I have a number of fill-in forms I created with Word 2000. Many have dropdown boxes that contain a number of responses as well as a "blank" option (created using blank spaces) to allow us to 'clear' the field if nothing has to be filled in. We recently switched to Word 2007 and we have been unable to select the "blank" entry in the dropdowns, therefore, we can no longer clear a field if no entry is required. Am I overlooking something? If you use the legacy dropdown fields in a protected form then Word 2007 will certainly allow a blank entry consi...

Creating a form / card
Hi there. Was hoping someone could help, been trying for ages. All I want to do is remove all the excess cells and space from my work-sheet so that I get a nice tidy form / card. Thanks so much. Dan -- dhunter84 ------------------------------------------------------------------------ dhunter84's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33373 View this thread: http://www.excelforum.com/showthread.php?threadid=531997 Dan, you can't remove them but you can hide them, select the rows you want to hide and format rows hide, do the same for the columns...

adding specific "Lead Source" contact or account to Lead form?
The Lead form has a "Lead Source." When the lead source is "External Referral" we'd like to track the actual Contact (or Account) so we can send them a thank you or special offer. How can we create a "Lookup" attribute (relationship?) from the Lead to a Contact and put it on the Lead form for the user to select a lead source contact from the search Contacts form? Would using the Referral field help? -- Larry Lentz [CRM MVP] MCSE+I, MCSE W2K, MCDBA, MCSA Messaging Lentz Computer Services Microsoft Small Business Specialist San Antonio, Texas Larry@LentzCo...

how to print reference label name in excel for comments?
I have chosen to print comments at the bottom of my spreadsheet the problems is it only gives the cell reference number. If I am looking at a printed version I would not know what cell it is refering to. I then labeled (reference) each cell but it still does not print out the name of the cell. How can I print out the label name oppose to $b$3$? Go to Print, Page Setup, Sheet, and select (under print), row and column headings. This will print out the headings just as you see them on your monitor. HTH Carole O "Needhelp" wrote: > I have chosen to print comments at the ...

access 2007 form sql subform
When i use a database with linked table on sql 2005, each time i open a form with subform, access load all the record before showing the form. If the table has many records, it's taking a long time (30 seconds) before loading the form (a table with 30000 records and 100 fields). With access 2, 95, 97, 2000, 2003, it worked fine. Only a few pages of data on opening Guy Instead of binding the entire recordset (table) to the form, and the entire recordset (table) to the subform, consider using something, say, like an unbound combobox in the header of the main form to allow selection ...

Form Coding
Do I not have this correct? In VB for a form, I want to call a particular field from the query the form uses. The query has multiple tables attached to or in it. Affiliates is one of the table names. Email is the name of the field in Affiliates. So, shouldn't the code be if I want to reference that box? Me.Affiliates.Email It isn't work... Curtis Nevermind, realized I didn't have a box on my main form calling or dislpaying that field, the code I was using was in an event for a button... Curtis > Do I not have this correct? > > In VB for a form, I want to c...

how do I generate a bill from an order form?
It depends... In what format is the order form? Hard copy? If so, then you would have to type in the data from the order form. If the order form is in some type of soft copy, then you would want to open that file with Excel. The Help file will tell you how to do this. If the order form exists as a record in a database, then you would need to coax Excel to query the database to get the data. The Help file will (sort of) tell you how to do this. Once you have the data in Excel, then you can manipulate it as you wish. That is about all I can say without greater detail regarding the cha...

Excluding worksheets from printing
Hi, I currently embed an Excel macro in my spreadsheets which will print the entire workbook (40+ sheets) should the user request it: Private Sub CommandButton2_Click() Dim Sheet As Worksheet Dim lAnswer As Long lAnswer = MsgBox("This report contains " & Sheets.Count & " sheets - Do you want to print them all?", vbYesNo, "Print?") If lAnswer = vbNo Then Exit Sub Else Worksheets.Select Application.Dialogs(xlDialogPrint).Show Sheets("Total").Select End If End Sub However, I have now incorporated several workings sheets that a...

Print Titles
Hi, I need some help please. I have a sheet with lists of peoples names and other specific data. I'm able to sort these and sub-total them into groups of the same name and print these on separate pages. I've set up a header so it prints at the top of every page through "print titles". This is fine and I'm happy with this. What I'm trying to do is to have the name of the person in the "header" that appears at the top every page. But how? Many thanks MM Are all these groups on the same worksheet? If so, you are allowed only one &qu...

Can Publisher print divided page ranges?
With Ms-Word, you can specify several ranges of pages, using commas as delimiters, such as: 1-4,9,10-12 This doesn't seem possible with Ms-Publisher 2003, but maybe I'm missing something. It only seems possible to indicate one range, such as 3-10 Is there a way to have just certain pages print out such that several ranges are involved? I'm trying to accomplish the equivalent of Ms-Word's "MasterDocument" by having a 40 page master, from which I can specify a 12 page version, a 28 page version, etc. The twelve page version might be something like: 1-3,8-9,10,14,36-4...

Lease agreement forms
Is there any template forms I can get for leasing an apartment? I am looking for a roommate, and I need a form for potential roommates to sign and have some sort of lease agreement. I am renting out an extra room in my house. Thanks! Try this here: http://office.microsoft.com/en-us/templates/results.aspx?qu=rental&av=TPL000 And more specifically this one: http://office.microsoft.com/search/redir.aspx?assetid=TC010014651033&QueryID=GtNChmW1K0&respos=5&rt=2&pid=CT101481321033 -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.bta...

Printing Problems #4
Dear all i group some spreadsheets but when i press the print function on the spooling it breaks the pages by 1, 12, 2, 3 so its group have differrent printing preferences.. It is excel XP Can anyone help me with that? Regards Manos ...

Bar Code Printing
Greetings: I am looking for advice regarding bar code label printing with Access. My non-profit organization receives donated items that are sold in our store. I want to track this inventory by attaching a bar code label to the merchandise when it is received so the donor will receive proper credit when the item is sold. Ideally, the barcode will contain the donor's information as it is entered into the database. Then, it would be nice if scanning the barcode on the item would bring up the donor's record from the database (sort of a two-way operation). Can anyone give me a few tip...

2003 Publishing my print smears on back of business card. Any idea
Using a ink jet HP printer, when I place text on back of busness card it smears. Does anyone know to correct or prevent this? Thanks. HCGordon On Mon, 1 Nov 2004 09:26:04 -0800, "HCGordon" <HCGordon@discussions.microsoft.com> wrote: >Using a ink jet HP printer, when I place text on back of busness card it >smears. Does anyone know to correct or prevent this? Thanks. HCGordon More info, please. What kind of paper are you using? Are you using any graphics on the cards? Blessed be, for sure... Jim-I'm using Avery Business Card 8879-Extra Sturdy, photo quality ...

after apply filter show blank form.How to detect 0 records??
hi I Have a form , and the user goes to filter by form and then apply filter. When no rows are returned a blank form is displayed how do I detect this and display a message 'no rows found'? mike Mike, I would like to say add a piece of line to your code... DCount("SomeField","SomeTable") < 0 Then MsgBox Esle run your filter but you didn't post any code. Perhaps that little tidbit I posted is enough to get you started? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!&quo...

Create Table Record on Current of Form
I have a table called LastVisitedRecord. There is but one field in that table called "lvCompanyID". I'd like to use the OnCurrent event of my record form to insert the record id (CompanyID) into a new record in the LastVisitedRecord table. After that, I'd like to use a query I've created qLastVisitedRecord which only shows the top 1 record of the LastVisitedRecord table to query my contact form by default, showing all records, but skipping to the record whose CompanyID field matches the sole record in the query qLastVisitedRecord. Anybody got an idea on how to do this? ...

automate printing
We have an excell file that has different sheets that need to be emaile to different departements within our organization. We are trying t automate the system so that it will print the sheets that go to eac department automatically. Example: 1 sheet to dept a the next sheet will go to dept b we tried using print to file but it does not give us a usable file tha can be emailed. Can someone help us with this -- Message posted from http://www.ExcelForum.com Look at Ron de Bruin's web site for different approaches to emailing workbooks, worksheets and so on. http://www.rondebruin.nl/ R...

Images on Forms
Does anyone know if an image can be added to a form? For example, we'd like to put an image of our 3-party supplier items on their records in the product catalog. I'm currently going down the path of the IFRAME and linking to the supplier website, but I'd like something cleaner. I'm on 3.0 currently but will be upgrading to 4.0 soon, so if it can be in 4.0 I can wait. Thanks. -- BC My suggestion would be to add you image as a note from the related record and retrieve it at-runtime using client side script (web service call) or any custom aspx page from a menu entry...