You are correct in your assumption.

32 fields is maximum allowed in a data from.

The width of the form is governed by the width of the columns.

I learn something new every day.

My only suggestion is to truncate some of the field widths.


Gord

On Wed, 10 Jan 2007 03:58:00 -0800, dfrost57
wrote:

Yes I am refering to the built in Data Form. I have 32 columns which forces
the data form to create two columns. I have done some tests and it appears to
be driven by the width of the columns in my database.

"Gord Dibben" wrote:

Are you talking about the built-in Form you access from DataForm?

I have never seen such a phenomenom with that Form.

Or one you have created?

In which case, you control that when creating it.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 12:01:00 -0800, dfrost57
wrote:

I am using Excel 2003. When I open my data form to review records in my
worksheet the form is wider than my screen. Can I resize the form?