getting #size error in print preview

I have a daily report of appointments that I want to print regardless if there are appointments or not.

I set the control source on the [Appointment Date] field to say: IIf([Appointment Date] isNull,[Appointment Date])

This displays great in Report View, but in Print Preview I get a #size! error in that field.

Sponsored Links:

Related Topics

Best practice for print preview and print a report
Typically when you print something, you get a print preview (with focus) and then print dialog to print to a printer of choice. How can you accomplish this ni Access 2007? I can go straight to print, and I can preview (unfocused tab) or preview as popup, then magnify/demagnify with mouse and click ribbon print button.


Print Preview for Forms
I have a database with a Switchboard and a number of forms, etc. When I open a form and search for a particular set of data I can print it with the print button that I have installed on the form, but if I go to the print preview it shows the first line of data in the table and that is what prints from the print preview. How can I direct the print preview to follow what is on the form


Print vs. Print Preview
I am adding a report to an Access 2007 Db that will end up being a Runtime version. On the switchboard (actually a form I'm using as my switchboard) I have a button to print this report.

Here's the problem. When I click the button to print the report, it opens the report in "Print Preview", but I'm seeing a blank report and a Print window. if I click on "Print", the report prints AND I get to see the Print Preview.

However, if I click on "Cancel", I am allowed to see the Print Preview, but have then lost theability to Print.

What I was hoping was that the Print Preview would open so my users might decide if they wish to print or cancel.


Multiple Print Previews at One Time
I have a database with several places an operator may request print previews. Currently, if an operator runs a print preview (my VBA code is docmd.OpenReport "Report Name", acPreview), the report opens in preview mode and the operator may view it.

However, if the operator leaves the preview on the screen and selects another tab and requests another print preview with the same report name, but different selection criteria, the first preview remains unchanged and the second one doesn't appear.

I would like it to open in a separate window so the operator may toggle between the preview windows to see both reports.


Print a report without displaying print preview
I have several forms which have a print button (created with the command button wizard, report operations, print report, then relevant report is chosen to print). This works great, and prints the relevant report for the the associated record, however when you click the print button it also displays the print preview and doesn't close it again. This means that until the preview is closed the same thing keeps printing when the button is clicked.

but I've managed to looked in the button's properties, and it's created a macro - runcommand, print. When you click on that line there is a description called view from which you can choose either print, design, preview, layout etc, I've tried changing it to all of the other options, but the only one that makes the report work is preview.


Print Preview with a Runtime DB
I have created a report in a ".accdb" database. I open the report with an OpenReport macro with the View set to Print Preview. When I run the report the Print Preview tab opens and the Print icon is active and displayed in the right corner.
When I convert the db to Runtime (.accdr) and run the report, the Print icon is greyed out and I have to click the Office Button and select Print in order to print the report.
Is there any way to get the Print Icon active in Print Preview in a RunTime database?


Preview and print a report
This article explains how to preview and print a report that was created with or opened in Microsoft Office Access 2007. This article also provides basic information about how to change commonly used print settings, such as the margins and the number of columns on a printed page.
What do you want to do?
* Preview a report
* Print a report quickly
* Print select pages from a report
* Change the page setup
* Select print options
* Print a report about your database


Access button to print report instead of opening it in print preview
I currently have a button that opens a report in a print preview. I'd like to change this button to just print (by passing having to click print and then close the print preview). The current button does this:

Private Sub Command842_Click()
Dim stDocName As String
stDocName = "rptWarrantyCard"
DoCmd.OpenReport stDocName, acViewPreview, , "[wo_id] = " & Me.wo_id
End Sub

Is there an easy way to print and bypass the preview, such as changing it to DoCmd.PrintReport? I'm not much of a coder, so I don't know the syntax


Printing Report on opening print preview without dialog box
I was wondering if it were possible to print a report after it opens in print preview but without the dialog box (and here's the kicker) while a form sub is still running. I figured out DoCmd.PrintOut will print without the dialog box but it wont run while Access is still running a sub from a form. (It gives a Run-time error 2585: This action can't be carried out while processing a form or report event.) The other thing I tried was putting RunCommand acCmdPrint after the open report line but that results in the unwanted print dialog box. Is there anyway to achieve this? I need the report to load in Print Preview as there is script in the onload bit of the report that needs to run in order for it to be printed correctly


Printing Report on opening print preview without dialog box
I was wondering if it were possible to print a report after it opens in print preview but without the dialog box (and here's the kicker) while a form sub is still running.

I figured out DoCmd.PrintOut will print without the dialog box but it wont run while Access is still running a sub from a form. (It gives a Run-time error 2585: This action can't be carriedout while processing a form or report event.)

The other thing I tried was putting RunCommand acCmdPrint after the open report line but that results in the unwanted print dialog box. Is there anyway to achieve this? I need the report to load in Print Preview as there is script in the onload bit of the report that needs to run in order for it to be printed correctly.


Report View/Print Preview (sub report) Problem
I have a report that has several sub reports. It could be possible that sometimes the sub report(s) returns with no records, which is fine. When viewing the report in report view, the subreport is displayed with no records (this is what I want) but when viewed in print preview, it's not there and it is causing calculation problems in my main report.

I run calculations from the sub reports to get a cost estimate on the main report and when the report is not displayed in print preview, it returns "#Error". I need what is displayed in the report view to actually print.

Or find how I can run my calculations if it doesn't load in print preview and printed.

The report is called rpt_TDY_Summary.


unbound text box data not appearing in print preview
I have a form with some unbound and bound controls. The form has a record source. When the form is run and controls are populated via a query (the recordsource), the user enters data in some unbound controls. The form also has a button which displays in print preview mode.

When the custom print preview button is clicked, the data from the unbound controls do not appear in the preview. But if I use the file-print preview menu item, the data is properly seen.

Below is the code written in the button click to display print preview

DoCmd.SelectObject acForm, "AnswerForm"
Printer.Orientation = acPRORLandscape
DoCmd.RunCommand acCmdPrintPreview
DoCmd.Maximize

I am unable to figure out why this behavior is happening. Any help with this is appreciated a lot.


Possible to add "Print" menu from Print Preview?
Just wanted to know if there is a way to enable a small menu for the user to print once a report is in print preview mode. I have the report appear in print preview mode pop up in a form. Other than right clicking and pressing print that way, is there a way to add a print button to the pop up form


print preview and exported file differences!
when I preview a report or print preview everything is ok. If I right click print preview and export to pdf, again no problem.

However if I have a button on a form which saves the report to file I have differences.

Inside the report there is some rectangles which make up a graph, and are calculated when the form is opened (on load) using code.

As the report is not opening, it is just going to file, these calculations are not being performed. Whats the best way to ensure my report comes out


Show Print Ribbon In Report Preview, Office 2010
In my Access 2010 database I have disabled:
* Display Navigation Pane
* Allow Full Menus
* Allow default shortcut Menus

This gives the user a clean screen.

If I open a report in preview mode, how can I show the Print Preview ribbon to allow users to actually print or close the report.
And hide the Print Preview ribbon when the user closes the report.

I am using VBA

My reports are not pop-ups
My database is not on the web, but on a local network


Access 2003 Printing Problems
I am unable to create a print command button on a form as an error occurs. I have checked the file menu and I am unable to print preview or print any forms as well. The print icon on thetoolbar also states there is no printer when I scroll over it, but I am connected to a network printer and can print to it from any other application.


Default View Print Preview
How can I make Print Preview the default view for a report straight out of the switchboard? Currently when you click to open a report it opens in report view and you have to right click to select Print view. In design view my report says the default view is Print Preview but that is only for opening it directly. When you select from the switchboard menu that option doesn't exist. Is there a way to get the print preview to be the default view


Print preview with forms
I have a form with controls to print reports, I am using print preview so I can select which printer to use. The results is the form gets printed, not the report.


Printing report in landscape & legal size
I'm having a problem with printing a report. I set the report to print in landscape but all the columns arent fitting on the page so I changed the page setup from design view to legal size paper but for some reason the last column is not printing even on legal size.

I would be fine even if the last column printed on the second page by itself but its not even doing that it just cuts it off and when it prints its only printing one page and the report is multiple pages long.

The users will be printing from database view not design view, I have a print button on the reports page that is working fine the only issue is that the report is only printing the 1st pageand the last column is not printing at all as mentioned before.

Is there a way using VBA that when the print button is hit from database view that will open a print dialog box or print preview so the options of number of pages and paper size can be chosen?

Here is the basic code I have set on the print button, everything I have tired has failed:


passing criteria Query from REPORT to Print Preview
I have a Report that is generated from a querie with the usual criteria Between [StartDate]and[EndDate] which works fine but when I choose to print preview it asks for the Criteria again I figured a way around it with a button macro to blind print but as you prob have experienced Report view data can look different to Printed Data from time to time so to be able to go from Report view to Print Preview mode without repeating Critera would be great