Oh I see!!!
The number of fields the Report wizard can accept is dependent on the size
of each field. No sure fire way of knowing exactly what the Report Wizard
will accept.
754 Controls is the maximum (in theory) that you can manually add to a
Report. Again I say in theory!!!
Eric
--------------------
| Content-Class: urn:content-classes:message
| From: "Lei" <
[email protected]>
| Sender: "Lei" <
[email protected]>
| References: <
[email protected]>
<7hK#
[email protected]>
| Subject: RE: Access report
| Date: Mon, 1 Mar 2004 07:27:14 -0800
| Lines: 89
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP/oaw1zMLrcuNdRVyAUq2OKIBxvA==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:8818
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.access.security
|
| Eric,
|
| Actually I create the report based on an existing query
| which has 69 fields totally. An error message " The
| wizard is unable to create your report or form because
| you choose too many fields, please try again with fewer
| fields" when I use the wizard to set the report
| layout in tabular, but not in columnar.
|
| Does the 375 means the max number of fields allowed in a
| tabular
| layout report? what's the 754 controls mean? Do you think
| if there are something wrong in my creating report
| process?
|
| Thank you very much!
| Lei
|
| >-----Original Message-----
| >Hi Lei,
| >
| >The Microsoft Access help topic "Specification" states
| over the life time
| >of the Form/Report you can have 754 controls. But keep
| in mind that's not
| >exact (i.e., other variables come into play).
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><
http://www.microsoft.com/security/security_bulletins/ms0
| 3-026.asp> and/or
| >to visit Windows Update at
| <
http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Lei" <
[email protected]>
| >| Sender: "Lei" <
[email protected]>
| >| Subject: Access report
| >| Date: Fri, 27 Feb 2004 08:05:52 -0800
| >| Lines: 5
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| Thread-Index: AcP9S5Mbluhy22f8SVu4gk+jd6a/BA==
| >| Newsgroups: microsoft.public.access.security
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.security:8757
| >| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| >| X-Tomcat-NG: microsoft.public.access.security
| >|
| >| Does anyone know what's the max number of fields
| allowed
| >| in an access report?
| >|
| >| Thanks!
| >|
| >|
| >
| >.
| >
|
