Topics Search

getting #size error in print preview

getting #size error in print preview
Views: 39
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:

Similar posts...

 

Best practice for print preview and print a report

Best practice for print preview and print a report Icon
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 vs. Print Preview

Print vs. Print Preview Icon
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.
 

Print a report without displaying print preview

Print a report without displaying print preview Icon
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.
 

Multiple Print Previews at One Time

Multiple Print Previews at One Time Icon
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 Preview with a Runtime DB

Print Preview with a Runtime DB Icon
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

Preview and print a report Icon
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
 

Report View/Print Preview (sub report) Problem

Report View/Print Preview (sub report) Problem Icon
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.
 

Access 2003 Printing Problems

Access 2003 Printing Problems Icon
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.
 

Print preview with forms

Print preview with forms Icon
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.
 

Events not firing when printing.

Events not firing when printing. Icon
We are looking for suggestions on how to fix a print problem. We have an invoice as Form. We are trying to print multiple records of the invoice. When we go to print the events are not firing.

Is there a way to make Access update the events before trying to print each record? They look perfect on the screen, they are not updating when you print or print preview. We know a report would work better.

We are trying to print multiple forms at a time by filtering on a date, then clicking File | Print. We do a File | Print Preview first to check out what will be printed. We do not use a button to initiate printing as assumed. The form has two sub-forms.