Adding a text box?

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I currently ran into a problem where I'm getting an error
message stating: Microsoft Access can't create any more
controls on this form or report. Whenever I try to put
another text box on the report this message appears. Are
there some kind of limitations on how many text boxes can
be put in a report? Any suggestions on how to get around
this would be greatly appreciated. Thanks
 
Yes there is a limit. If I remember correctly it's somewhere between 600 and 700. Every
item counts; labels, lines, textboxes, rectangles, etc. I also found that once you hit the
limit, trying to delete controls is very, very slow (especially if you select several at
once for deletion) until you get down around 550. I assume the reason for this is Access
is actually creating temporary items as it deletes the controls and you're out of room for
creating more items. I selected 20 controls one time and pressed the delete key and Access
would only delete 2 or 3 then quit deleting. I had to go back and select the rest of them
again.

One of the easiest work-arounds I've found is to use a subreport. It appears to count as
only one item on the main report and can then have its on set of controls. Another
work-around is to concatenate some of the text into single textboxes so that you don't
need as many.

Example:
Instead of a first name and a last name textbox, use one textbox with its control source
set to:
=[FirstName] & " " & [LastName]
 
Back
Top