Screen Split & Text Box Count

[Shannon]

Suddenly (I must have bumped something), the screen in form view split
between detail and footer, making detail very small, so you must scroll to
see the whole record. I created it tightly, to make sure it fit in a small
window, but not as small as it suddenly made itself. I can't undo either.
How can I make it back to the original default screen? I can't see a
difference in design view.

Also, I'm adding Text Box's to count survey results Y/N's. Suddenly (again)
Access won't let me add any more text boxes without putting #ERROR for the
result. If I tweak it down to 9 text boxes, the correct results show. I
want a whole bunch of text boxes. What can I do?

 

[kingston via AccessMonster.com]

In design view, check the form's Auto Resize value. As far as your second
problem is concerned, have you considered combining results into one text box
or concatenating the results in a query first?