export data from form to excel

  • Thread starter Thread starter Carla x via AccessMonster.com
  • Start date Start date
C

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
 
Heeeeeeeeeelp
Carla

Carla said:
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
Click to expand...
 
Back
Top