export data from form to excel

[Carla x via AccessMonster.com]

I've designed a form that contains some unbound controls (text box). The
controls are populated from the vba code (using sql). When I export the
information (“OfficeLinks" button), of the form, to excel, it’s displayed in
a single row. Is there any way to break this row?
For example:
in the form the data is displayed like:
control1 control2 control3
control4 control5 control6

When exported to excel:

control1 control2 control3 control4 control5 control6

It doesn’t break after the control3

Is there any way to export the data at the way i want?
Thanks,
Carla

 

[sigava77 via AccessMonster.com]

Heeeeeeeeeelp
Carla

I've designed a form that contains some unbound controls (text box). The
controls are populated from the vba code (using sql). When I export the
information (“OfficeLinks" button), of the form, to excel, it’s displayed in
a single row. Is there any way to break this row?
For example:
in the form the data is displayed like:
control1 control2 control3
control4 control5 control6

When exported to excel:

control1 control2 control3 control4 control5 control6

It doesn’t break after the control3

Is there any way to export the data at the way i want?
Thanks,
Carla