# soft number of columns

[Vsn]

Hi,

How can i set the number of columns I would like to use, in VBA at the, i
suppose, Report_Open event?

Thx,
Ludovic

 

[Allen Browne]

You can CreateReportControl only in design view.
That's not very practical, e.g. it prevents you creating an MDE.

A better solution is to place an text box on the report for every field you
may need. Then in Report_Open:
- show/hide the text boxes you need (Visible property),
- place and size them (Left, Top, Width),
- bind them (Control Source.)

If you name them appropriately (e.g. Text0 to Text99), you can refer to them
in a loop like this:
Me.Controls("Text" & i)

 

[Vsn]

Allan, thx. I thought it to be possible just to set the number of columns in
VBA code at the Open_report event.

Ludovic