Subform in data sheet view

[Dana Stricker]

I have several subforms that people enter data on. The subfrom is in
datasheet view as a result they can adjust the columns. The problem is that
the subform populates a report and if the end user changes the width of the
columns then the report does not print correctly. How can I stop this?

Thanks,
Dana

 

[Maurice]

I assume you have a print button somewere on the form. If that's the case you
can set the columnwidths in code

try something like me.fieldname.columnwidth=xx

where ofcourse you have to reference the subformcontrols and the subformname
which coul be something like:

forms!mainformname!subformname!form.fieldname.columnwidth=xx

where xx stands for the designated with of the field.

hth