Sending forms results to Excel

[Guest]

The results of my form are being sent to _private/adult.csv. When I open
this in Excel, it isn't in the order I want. I set the tab order in the form
design, but that's not working.

My form is in a table & looks like this:
# clients # staff resigned
# staff # discipliinary

On Excel, I'd like the list to be #clients, #staff, # staff res., # disc.;
but instead the list is #clients, # staff res., #staff, # disc.

Will I need to re-do my form?

Thanks in advance.

 

[Thomas A. Rowe]

Textareas will always appear last when using the FP Form Handler. You would have to use ASP, etc and
database to solve.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Andrew Murray]

The "tab order" has nothing to do with the order the results are written to
the file.

The Tab order is the order that a person tabs through the actual fields in
the form - when they press the "Tab" key the cursor jumps to the next field;
the order of the 'jumping' between fields can be specified in each field's
properties.

There is a form properties option that allows you change the fields to
include when writing the data to the file, but not the order. The order of
the fields & data in the data file are determined by how you've laid out the
form in the first instance..