# soft number of columns

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

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)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Vsn" vsn at hotmail wrote in message
...

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

Thx,
Ludovic

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

Ludovic


"Allen Browne" wrote in message
...
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)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Vsn" vsn at hotmail wrote in message
...

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

Thx,
Ludovic