number of controls on the report

[iccsi]

I have a report which has many contols on the report.

I got error message when I put a new controls. I know that the maximum
controls on the form is 754.

I just want to know that does controls on the subreports count and is
it possible to get the number of controls on the reports?


Your help is greate appreciated,

 

[Marshall Barton]

I have a report which has many contols on the report.

I got error message when I put a new controls. I know that the maximum
controls on the form is 754.

I just want to know that does controls on the subreports count and is
it possible to get the number of controls on the reports?

When the report is open in preview or design view, you can
display the number of controls in the Immediate window by
using:

?Reports![name of report].Controls.Count

If you are at the 754 limit, then first try compacting the
database (after making a backup copy) and check again.

If you are really up against the limit, then using a
subreport will allow you to add another 754 controls in the
subreport. Don't forget that a subreport control counts as
one control on the main report.

 

[John Spencer]

Another point is that the 754 count is over the lifetime of the report
object. If you have a report and add 100 controls and save the change
and then open the report and delete the 100 controls you have added,
then those 100 "slots" have been used and are not recovered.

USUALLY if you compact and repair the slots will be recovered OR if you
do a save as I think (I'm not sure) the slots may be recovered in the
new version of the report.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I have a report which has many contols on the report.

I got error message when I put a new controls. I know that the maximum
controls on the form is 754.

I just want to know that does controls on the subreports count and is
it possible to get the number of controls on the reports?

When the report is open in preview or design view, you can
display the number of controls in the Immediate window by
using:

?Reports![name of report].Controls.Count

If you are at the 754 limit, then first try compacting the
database (after making a backup copy) and check again.

If you are really up against the limit, then using a
subreport will allow you to add another 754 controls in the
subreport. Don't forget that a subreport control counts as
one control on the main report.

 

[iccsi]

Another point is that the 754 count is over the lifetime of the report
object.  If you have a report and add 100 controls and save the change
and then open the report and delete the 100 controls you have added,
then those 100 "slots" have been used and are not recovered.

USUALLY if you compact and repair the slots will be recovered OR if you
do a save as I think (I'm not sure) the slots may be recovered in the
new version of the report.

'====================================================
  John Spencer
  Access MVP 2002-2005, 2007
  Center for Health Program Development and Management
  University of Maryland Baltimore County
'====================================================

iccsi wrote:

When the report is open in preview or design view, you can
display the number of controls in the Immediate window by
using:

?Reports![name of report].Controls.Count

If you are at the 754 limit, then first try compacting the
database (after making a backup copy) and check again.

If you are really up against the limit, then using a
subreport will allow you to add another 754 controls in the
subreport.  Don't forget that a subreport control counts as
one control on the main report.- Hide quoted text -

- Show quoted text -

Thanks millions,