Using the NewRowOrCol property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELP !!!!!! DESPERATE WORKER !!!!

I am using the New Row Or Col property within my report to format my
columns, which works great. However, I need to be able to set this property
programmatically using VB. I can get access to the proerty using
Me.Section(12).NewRowOrCol which will tell me the value of the property (0,
1, 2 or 3) but I haven't been able to find a way to set this value.

Advice please......
 
According to Access help, the NewRowOrCol property can only be set in the
report design view. Therefore you will have to open the report in design
view, hidden if you prefer, and set the value.

For example:

DoCmd.OpenReport "MyReport", acViewDesign, , , acHidden

'Code to set the NewRowOrCol property here
Reports("MyReport").Section(12).NewRowOrCol = 3

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


HELP !!!!!! DESPERATE WORKER !!!!

I am using the New Row Or Col property within my report to format my
columns, which works great. However, I need to be able to set this property
programmatically using VB. I can get access to the proerty using
Me.Section(12).NewRowOrCol which will tell me the value of the property (0,
1, 2 or 3) but I haven't been able to find a way to set this value.

Advice please......
 
Thank you for your help. But sad to say that it didn't do what I need, which
is for the NewRowOrCol property to be a switch, to be turned on and off while
the report is being processed (depending on a flag). The code (?) might go in
an event in the Detail section of the report, probably OnPrint.

Brief synopsis: My report contains 4 columns and each column should contain
2 paragraphs, the paragraphs are kept together. At the moment Access will
sometimes print 3 paragraphs in a column, depending on the size of the
paragraphs (not good...). So we arrive at my current dilema, I want to force
Access to print on a new column after the 2nd paragraph. Call me a cynic but
I am beginning to think that this can not be done !!!

Many Thanks again for your help.
 
Again, according to Access help, this value can only be set in design view.
Based on that information, you will be unable to change the value while the
report is processing.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Thank you for your help. But sad to say that it didn't do what I need, which
is for the NewRowOrCol property to be a switch, to be turned on and off
while
the report is being processed (depending on a flag). The code (?) might go
in
an event in the Detail section of the report, probably OnPrint.

Brief synopsis: My report contains 4 columns and each column should contain
2 paragraphs, the paragraphs are kept together. At the moment Access will
sometimes print 3 paragraphs in a column, depending on the size of the
paragraphs (not good...). So we arrive at my current dilema, I want to force
Access to print on a new column after the 2nd paragraph. Call me a cynic but
I am beginning to think that this can not be done !!!

Many Thanks again for your help.
 
Back
Top