Re: Hot do I Fix the number of records displayed on a report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

could you either shrink the design and then select to allow it to grown when there is 10. it will not have the space then.

however, if you want to see blank detail lines, add five more opportunities in your form (table) with all details blank except for the key (autonumber/record number; however you have it set), but if you have that field on your report, the number will show. this however will show the reader you are still looking for five more opportunities.

my thoughts, your design!


"wzb6k5" <wzb6k5@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5B2D1169-4DB1-46E1-9E9C-9041EA42E1EE@xxxxxxxxxxxxxxxx
I have a report that needs to show the top 10 sales opportunities. I have it
setup and it works fine as long as there are actually 10 opportunities that
get returned from the query. The problem is that if only 5 opportunities
happen to exist, it only shows the 5 lines of opportunities. I need it to
show blank lines for the other 5. I have it laid out so it looks like a
table.

The reason this is a problem, is that I actually have 3 different tables
like this on a report one right after another. If one only shows 5 lines,
instead of the 10 I have the space allocated for, it leave a big blank area
in the middle of the report, which does not look good.

Any thoughts/suggestions?

.

Relevant Pages

  • Re: ISE software bug???
    ... The design & report files attached below. ... TIMING REPORT ... Add Generic Clock Buffer: 8 ...
    (comp.arch.fpga)
  • Re: Date range on reports
    ... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Date range on reports
    ... Without knowing where your report parameters were coming from, ... >>> open an Access database or an Access project. ... >>> In the New Form dialog box, click Design View, and click OK. ... >>> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)