Data Form Problem

  • Thread starter Thread starter KLassman
  • Start date Start date
K

KLassman

I have a fairly simple table, with about 7 columns of data which I have
created for a co-worker. Most rows contain a single line of data,
but the last one of the fields uses "wrap text" and may have as many as
7-10 lines in that field. I am trying to make it so she can use the
Data Form method for data input. I am able to get the Form to be
created, but it says I only have one record . . . when very clearly
there are many more records. Does anyone know why this might be?
I thought it might be because of the "wrap text" in the one column . .
. and so I tried creating the form using only the first 6 columns but
even that didn't work. Any suggestions would be greatly appreciated.
 
If you have a blank row in the middle of your data, it may stop before that
and have fewer rows than you think. Try selecting the whole area before
choosing Data | Form and see if that fixes it. You could define the database
manually, but that's not a good idea because it won't necessarily expand. A
better idea would be to remove the blank row(s) that are confusing Excel.

If that doesn't help, please specify what version of Excel you're using and
an example of the column headers and data.

Regards -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
Thank you Frank. I'll print off your answer and try that tomorrow at
work. I don't think there are any blank rows, but there may be some
blank fields within a row . . . would that affect the Data Form also?
I believe I have Excel 2000.
 
Back
Top