Hi how do I set my preview size to 80% in Access 2003 when previewing
reports without having to zoom in every time.
Can this be done in the code that brings up the report?
Thanks Bob

Simple question (I think!):
Is it possible to have a report with the detail section as multi-column but
the group header/footer sections as single column?
Hope so (but I'm blowed if I can see how!).

Is there any kind of graphing capacity in Access like what Excel has?  If
there is it sure isn't obvious.

I have a form that I saved and opened as a report.  In it I have a column
listing groups shown as letters, ie A, B, C...Once I hit the end of the
alphabet I go to AA, BB, CC...I have it so the form shows A-Z first and then
continues with AA, BB, CC...

Some time ago, someone in this forum suggested the following code to hide
controls which are blank:
Dim ctl As Control
   For Each ctl In Me.GroupHeader0.Controls

I added a text box to the report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")
The code worked great but now I get #error in the detail line for part
number and

Someone knows this control?
It's possible to print it vertically?
Thanks Roby

I have a report with a number of calculated controls. Here is an example
=([Sum Of txtClients0]*[txtclientstotal])/[Sum Of txtClientsTot]
However if any of the data in the fields that these controls are based on
are 0 then I'm getting #Num! How can I change my calculation to show a ...

I have a Sorting and Grouping field in my report.  With in that grouping I
have =Count([StoreNumber]) that gives me a total for each grouping which is
the Bay Count..  Is there any way I can sort the report by the result of the
Count number? as you can see below I am now sorting ...

thanhk you

I have a crosstab query that has a parameter set up to ask the user for the
month to be displayed.  It works fine, but I can't create a report from it.
Can anyone help me with this?

Is it possible to invert a text box on a report?  We have some labels that
are upside down and we would like to be able to print on them, however we
need to turn everything upside down.  
Thanks for any help...

I have been searching for a way to fix this problem and to this point have
found nothing that will fix it.  I have two Reports that contain 5 child or
sub reports.  The two reports in question were designed in an Access 97
version database and have been in use for the last few ...

Hi can anyone help me,
I have just graduated and have started working for a building developer
which deals with a large quantity of drawings.  As you can imagine these all
need documenting and revision of drawings kept a track of.  I have recently

with the program printshop 2005 when i try to use the text a box comes up
stateing (JIT) Font ariel does not work with font ?