Row data missing from printed report

I'm printing a tabular report from Access 2003 in portrait on A3. On a row 
about half way down, it prints the grid lines and some of the fields, but 
misses other fields (all there on Print Preview or a Landscape print). 

Has anyone had this problem and solved it?
2/18/2010 4:34:02 PM
access.reports 4434 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 53


Open the report in design view, and check the properties of the problem text 
box(es.) Make sure:
- Display When is set to Always.
- Back Color is white
- Fore Color black (0)
- Font Size is 8 or greater
- Font Name is one you have installed.
If you have vertical set to Yes, try the font Arial CYR (not normal Arial.)
Then see if there are any other properties for this text box that are 
different to others on your report.

If the report prints characters (A-Z) but not digits (0-9) and you have the 
French language installed, there was a weird font problem relating to an 
Arabic font, (but I think that was an older version of Access.)

If none of that works, try switching to a completely different printer and 
see if it prints okay. If it does, see if you can get an updated driver for 
your printer.

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -
Reply to group, rather than allenbrowne at mvps dot org.

"Jerry K" <> wrote in message
> I'm printing a tabular report from Access 2003 in portrait on A3. On a row
> about half way down, it prints the grid lines and some of the fields, but
> misses other fields (all there on Print Preview or a Landscape print).
> Has anyone had this problem and solved it? 

2/19/2010 6:28:30 AM

Similar Artilces:

Pasting data from Excel
Hello everyone, I'm not sure if I should be posting this question here or in the Excel forum but here goes. Is it possible to copy data from multiple cells in Excel and then paste them into multiple lines of the criteria section of an Access query? For example, Given cells and values: A1- 1 A2- 2 A3- 3 I would like to be able to copy this data from Excel and paste it into an Access query like : Criteria: 1 or: 2 3 I am using Access 2002 SP3 and Exc...

Printing data forms
I would like to be able to print Excel data forms. Is there a way? In some event of the form (a button, a click of the form itself, whatever): Me.PrintForm "Curious" <> wrote in message news:170101c47bf9$f9191420$a301280a@phx.gbl... >I would like to be able to print Excel data forms. Is > there a way? If you mean the form you get when you do Data=>Form with the form displayed, do Alt+Print Screen. then drop the form and go to a new worksheet and do Edit=>Paste This will put an image of the form on the worksheet and yo...

Consolidation Worksheet Data Sequence
I'm consolidating 3 worksheets into one by using Excel 2007 data consolidation. The worksheets have a product number in column A and sales figures in columns B, C & D for Jan, Feb and Mar. The worksheets are in product number sequence. Not all product numbers appear on each sheet, so I consolidate by category using "labels in left column" and "create links to source data" to create a consolidation sheet in outline form. The problem is the consolidated worksheet is not in product number sequence as I need it to be. I have books on Excel 2007 and Excel 2003 and their ...

Free Data Process/Query Tool
If you use Excel everyday and spend lots of time on data/text processing, then you will find the this tool (UDQ Add-in) is very powerful and can speed up your daily data processing work. Currently the tool is free for everyone. Please feel free to distribute this tool to your friends/colleagues if you think it is helpful to your work. The following is a list of features/functionality of the tool: 1> Query/Import Data from Multiple External Data/Text/ASCII Files (Can useful import data from hundreds of files within minutes) 2> Query/Import Data from Multiple Closed Excel Files (Can...

How to adjust report width
Hi, I am trying to adjust the SOP Short invoice form width. Is it possible to extend the width of this report and how can I do this. Thanks in advance, -- Elaine Typically, the reports are set to read the printer settings for there width. You can change the report to print Landscape. On the Report Definition window, lookm at the Page Orientation section. One note about selecting the printer settings. If all your printers are not setup exactly the same, it could cause the report to print differently depending on which printer you send it to. -- "Elaine...

Print 2 receipts when selling item with rebate?
Is there any way to program rms to print multiple receipts on particullar items, for example I sell an automatic pool cleaner that has two differant mail in rebates and we always supply the customer with duplicate receipts Victor Out of the box, no. The easiest way is to train cashiers to use the Reprint function when they need a second copy. The other option is to configure the receipts to print 2 copies every time, but that's probably a waste of paper. I'm pretty sure this could be accomplished as a customization using the HTML status bar and QSBridge, but you would need a ...

Limits on Exporting Outlook Contact Data
Anyone know how to get custom fields, follow-up flags, and/or the "contacts" (links between contacts) from MS Outlook 2003 to Excel, CSV, Goldmine, or Act? The standard export utility in Outlook does not offer export of these fields. Most important is the links between contacts. You'd have to write your own code to do this. A key issue would be what information from the linked contact(s) you want to include. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode....

"Print Quote For Customer"
Using the Outlook client this option is under the file menu when you have a quote open. What template does this use and where do I download it from? ...

File Edit toolbar is missing
The File Edit toolbar in Excel is missing First thing to check: Tools|customize|toolbars tab|make sure worksheet menubar is selected. Well, maybe the first thing to check is to verify that you can see all of excel--it's not just off the display window??? stellarmellor wrote: > > The File Edit toolbar in Excel is missing -- Dave Peterson ...

Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout is perfect when printing to pdf (which is how the document will mostly be used) but the layout changes if printing direct to our printer. Is there a way that I can ONLY allow printing to pdf from this document? Hello You may consider using some VBA to achieve this. One way is to use the Workbook_BeforePrint event and specify the pdf printer in the PrintOut method, eg: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:" End Sub Pl...

excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it prints smaller unlike older excel program. Also when i set the margins for a spreadsheet the left hand margin wont move over to the edge of page like right hand side? In Page Setup: If you are using the Scaling option to print to a certain number of pages wide by pages tall and/or you are using the columns to repeat at left, try: - clearing the number of pages tall value (so that it is blank), and/or - if you are printing to one page wide, remove the columns to repeat at left Simon "Peter MB" wrote: >...

Select Rows dependant on certain field data
How can I select certain rows in a spreadsheet based upon the text foun in one column? To explain: All rows have a column that contains tex "immediate" or "ongoing" or "closed". How can I select only the row that contain the word "immediate" in that column? When I say select a mean select as in ready to 'copy' or 'cut' tha data ready to be pasted elsewhere. I know what I mean :confused -- Madd ----------------------------------------------------------------------- Maddy's Profile:

Magnify glass on report preview
Hi, I have a multi page report that I veiw using acPreview. When the report comes up my cursor is a magnify glass instead of the arrow. If I click on the next page arrow the cursor then changes to the arrow. Why? Thanks, ...

Add Invoice Number to Report
I have created a delivery table that contains all of the usual fields , Pickup, Delivery, Billing, NoPeices, Weight... etc. The table is updated with current delivery information daily. At the end of the week I create a report grouped on Billing customer that prints an invoice with all of the unprinted deliveries the customer is paying for... the report works fine. What I need to figure out is how to assign a unique invoice number (autonumber) to the report that will be associated with each Billing customer for that print period. Can I somehow generate a unique number at the time I ...

sort data without changing pattern
I have a worksheet where every other row has a 'pattern' in it to help make it easier to read across the spreadsheet. The problem I'm running into is as I add new rows at the bottom of the spreadsheet and then resort them into their correct place, the patterns go with the sort and now the patterns have to be redone again the get them back to every other row. Any suggestions? This will happen if your patterns are manually applied. It would be better to remove that manual shading and to apply background colours using conditional formatting, the condition being if th...

Customizing Contact Data
Is there a way to customize contact card/data to collect data from others that I want to use rather than the generic that Microsoft has used? -- Thank you very much. Tall Paul. "TallPaul" <> wrote in message > Is there a way to customize contact card/data to collect data from others > that I want to use rather than the generic that Microsoft has used? What type of information do you want to collect? -- Brian Tillman [MVP-Outlook] TallPaul wrote: > Is...

Updating large pivot source data
Hello, I'm experiencing the following problem with a very simple macro in Excel 2007 to update pivot table data source. That is, my data has more than 74000 rows and I'm trying to update the source data with the following code: Sub Macro1() Dim rng1 As Range Set rng1 = Sheets("Test_sheet").Range("A1:A74000") ActiveSheet.PivotTables("Pivot-taulukko1").ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:=rng1, _ Version:=xlPivotTableVersion12) End Sub The problem is that the code ...

Obtain data from list
I want to get the data from the list on to a cell in worksheet. I have 2 sheets - On Sheet 1 - I have drop downs. Whatever is selected in the list - I want to show that value in a cell on Sheet 2. Any help is greatly appreciated. Thanks! Hi, I think if you just change the properties of your dropdown so that the linked cell refers to the cell on your other sheet, it should work fine. Right-click on the dropdown and goto properties...Linkedcell. jeff >-----Original Message----- >I want to get the data from the list on to a cell in >worksheet. > >I have 2 sheets -...

Print preview anomoly
I have an application that was created in excel which has command buttons, drop down input fields, and Labels. Whenever I go to print preview all of the Visaul Basic command buttons, drop down input fields and labels move to the left of the paage being previewed. Closing the print preview window and the buttons stay to the left. Can anyone help. I have reloaded Office and I am using WIndows XP. This is an Excel 2002 SP3 bug:;en-us;838910&Product=xl2002 -- Jim Rech Excel MVP "Jerry Sanner" <anonymous@discussions.m...

Data Validation Allow List
Is there a way to click on the resulting combo box and have ALL the list items show up instead of just what seems like the default of about 8--I can scroll, but would like to just point and choose? Also, is there a way to change the font of this combo box? The resulting look like they are about 6 or 8 points. Any help is appreciated. Is this the right forum doug? If you are using a combo box (from the control toolbox) as opposed to a validation list you can change visible rows but not if you use validation Debra has a solution here -- R...

Add phone number to quote report.
Hey guys, My retail staff asked me if it is possible to add the customer phone number to the Quote summary or Quote detailed report. Does anyone know what changes need to be made to the report to make this happen. I know I will have to change the query and add a join statement to get it from the customer record but am unable to figure out how to do it. Any ideas? Thanks, Nevermind, I figured it out myself. Thanks anyway. <> wrote in message news:BhKXd.15130$GO5.11570@fe07.lga... > Hey guys, > > My retail staff asked me if it is possible to a...

Printing Externally #2
That works great...except it word brings up a message box stating tha Word is currently printing, if you exit, you will cancel you print.....and if i click no, so i dont close word, it still doesnt wan to print...any suggestions???Thank -- tess45 ----------------------------------------------------------------------- tess457's Profile: View this thread: There's a setting in MSWord that allows you to do background printing. I've turned this off--so Word do...

Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering assignment and I have added a worksheet that is basically an automatically generated report of all the calculations. I have set the Print Area up in such a way so that the results are printed out in well defined pages (e.g. page 1: title page, page 2: summary of input variables, page 3: summary of calculation results etc). The report is arranged vertically in the worksheet, so the pages are 'stacked' on top of each other. It prints out fine in Excel 2000 and 2002 but I recently upgraded to Excel 2003 and now find tha...

Period Sales Analysis Report Error
I updated to ver 10 from 9 SP2 a couple weeks ago and everything has worked relatively well (Thanks to all newsgroup members who assisted) I am getting an error "Error in equation 'Net Sales'". Has anyone else seen this and what did you do? I'm guessing this is a modified report? Open the report in Report Writer and check out the Calculated field 'Net Sales'. You will probably find an error there. If I can't figure it out just by looking, I'll look at the v 9 report to see what the calc was trying to come up with and then correct the formula in v ...

How do you change the rows to columns and columns to rows.
Ok, I am stumped on how to do this? I have a spreadsheed that has Dates in the A column and Data in the row. I want to make is so, the data is in the A column and Dates ru accross in the 1 column. How can I do this? Sound easy, but I am stumped??? :eek -- cc4digita ----------------------------------------------------------------------- cc4digital's Profile: View this thread: Highlight your data and copy it into the clipboard. Move to an open spot in the sprea...