form is based on a query that exceeds the limit for data in a single record

  • Thread starter Thread starter Kara
  • Start date Start date
K

Kara

Hi Everyone,

I have a database set up that uses a Switchboard to access
forms and queries. On one of them in particular, it is set
up to ask the user for criteria in their search and this
one specific criteria paramater kicks out the error "This
form or report is based on a query that exceeds the limit
for data in a single record. Exclude any unnecessary
fields from query, or change some of the field types to
Memo in the original tables.". The record that is being
pulled by the specific parameter is no longer than any
other record set up in this database, in fact, it is
shorter than most of them. I tried to open the form to
look at the form but can only look at it in design view.
If I try to open the blank form, I get the same message.

I'm at a loss. Any suggestions what I should look for?
Kara
 
See if you can run the query independently of the form. I bet you get the
same error. That is, the query truly is trying to return more than 2000-odd
characters per row, or whatever the exact limit is for the length of one
record. I doubt that the form, or the parameter, is anything to do with the
cause.

HTH,
TC
 
Hi TC,

Actually, if I run the query without the form, I don't get
the error. It will run successfully. It is bizarre. I
tried deleting the record and then all of my forms and
queries kicked out an error.

Kara
 
If the query works alone, but not when it is run from the form, then, the
form is doing something to cause the error. I would try to find out what
that is, rather than trying thngs (like deleting records) that might or
might not fix the problem :-)

HTH,
TC
 
Back
Top