bypass field limit in reports

  • Thread starter Thread starter cindy
  • Start date Start date
C

cindy

Hi-
I have a querry that has 161 fields, I need to do a
report with ALL fields...
I get a message that there are more fields than allowed -
is there anyway to bypass that max of 255?
thanks for your help!!!
Cindy
 
You may be able to get around this by placing some of the date in a
subreport. Another way around it may be to consolidate fields into
calculated controls. For example, instead of a text box for first name and
one for last name, you could use a single one.

=[FirstName] & " " & [LastName]

If this doesn't help the report, try making the calculated fields in the
query, this way there will be fewer fields sent to the report.

PersonName:[tblTable].[FirstName] & " " & [tblTable].[LastName]

Also, if there are any fields in the query that are there for filtering or
sorting purposes but aren't acutally used in the report, open the query in
design view and remove the check from the Show box for these fields. This
will reduce the number of fields sent to the report, but still provide the
filtering/criteria and sorting functionallity.
 
Thanks - I'll try that - I'm only over a few fields - so
mayb I can combine.
thanks again - Cindy
-----Original Message-----
You may be able to get around this by placing some of the date in a
subreport. Another way around it may be to consolidate fields into
calculated controls. For example, instead of a text box for first name and
one for last name, you could use a single one.

=[FirstName] & " " & [LastName]

If this doesn't help the report, try making the calculated fields in the
query, this way there will be fewer fields sent to the report.

PersonName:[tblTable].[FirstName] & " " & [tblTable]. [LastName]

Also, if there are any fields in the query that are there for filtering or
sorting purposes but aren't acutally used in the report, open the query in
design view and remove the check from the Show box for these fields. This
will reduce the number of fields sent to the report, but still provide the
filtering/criteria and sorting functionallity.

--
Wayne Morgan
MS Access MVP


Hi-
I have a querry that has 161 fields, I need to do a
report with ALL fields...
I get a message that there are more fields than allowed -
is there anyway to bypass that max of 255?
thanks for your help!!!
Cindy
Click to expand...


.
Click to expand...
 
Back
Top