From a command button on a form I have the following code to open a report: DoCmd.OpenReport "rptRouteMilesByTen", acViewPreview In the reports On Open code I...

I have created a report that has a lot of stuff on it that I need to print out on a 8.5 x 11 paper, but on the screen I have to use such a small font that it...

I have built a report with lots of small text boxes which I am trying to tidy up in the Report Design screen. I can find no way of getting the zoom function to...

Do any versions of Access (I haven't used 2007 yet) have an add-on for zooming in on the layout design area so smaller details can be seen? Almost every...

Is there a way to "zoom" at a report form during the design mode. I am designing a report with a lot of text. I want to enlarge the view during the design...

i have searched through the forums and found a way to set the zoom feature automatically to 100 so my user doesnt have to click all the time, but i get an...

Is there any way to zoom in on a report or form when in design mode? I have looked around 'View' and 'Window' on the tool bar, but could not find anything. ...

I have a access data I'm doing a mailing went into (report) and (labels) put the zipcode comes out as "123456789" instead of "12345-6789 any idea the (input...

i cant seem to print zip codes properly on access when i try to print them on labels. for example 92105-4545 prints out 921054545 with no dash i storing the...

Hello In my label query the zipcode looks like 00969-7659 In the labelreport it shows 009697659 How can I show the - sign in the report? I...

Please advise: I am trying to format the zip code field in my report. There currently are no hypens in the stored zip codes. I am entering the...

I have a report based on a query and suddenly it is duplicating pages. When I hit print preview - about 12 pages should come up and instead over 5,000 come up...

I want blank records to return a zero in either a report or the crosstab query the reports based on. Is there a simple way to do this?

Sorry posted this in Form group instead of here. I have a number of calculated controls ona report. If any of the fields contain a "0" I get #Num! This is a...

Greetings, I am in need of some assistance. I have a quarterly line chart that is not returning any zero values for quarters that do not have records. Is...

I have a report which includes 3 sub reports, each with a total. I have then added these 3 totals to give a grand total. However, if one of the sub reports...

I have a report with 8 columns across. We enter information into the fields in columns 1 through 6. Total of column 1 through 6 is automatically...

Can I reset a calculated field to null if the result of the calculation is zero? What I have is a report with four subreports in it. I have to add...

This is probably very simple: I have a report that displays many columns of numbers, many of which are zeroes. To make the report more readable, I would...

I'm trying to find a way to way to have Reports Display a 0 if no records are returned from my query. I've tried both Select and Crosstab queries. My current...