Adjusting Report Properites via code

[Mark]

Hi All,
I have set up a simple database to create labels for bottles. I insert a
set number of records into a table and have produced a label report based on
that table. After a bit of tweaking, the labels fit perfectly to the A4
label sheets I have.

The problem I have is that I want to the report to be dynamic. If I purchase
a different style of label, I need to go into the design of the report to
modify widths, heights, column counts, row counts, vertical spacing and
horizontal spacing.

I was thinking that I could have a parameter form where these values are
entered and the report resizes it's self when opened. I have tried adjusting
the width and height but I get an error message stating that the values I am
trying to change are Read Only!!

Could anyone offer any suggestions on how to do this if at all possible?

TIA,

Mark

[david epsom dot com dot au]

Most of those control properties are R/W in the section
format event while FormatCount = 1.

I don't think you want to change the Report height - just
let it shrink to size.

(david)

"Mark" <ma*********@ntlworld.com> wrote in message
news:AO****************@newsfe7-gui.ntli.net...

Hi All,
I have set up a simple database to create labels for bottles. I insert
a set number of records into a table and have produced a label report
based on that table. After a bit of tweaking, the labels fit perfectly to
the A4 label sheets I have.

The problem I have is that I want to the report to be dynamic. If I
purchase a different style of label, I need to go into the design of the
report to modify widths, heights, column counts, row counts, vertical
spacing and horizontal spacing.

I was thinking that I could have a parameter form where these values are
entered and the report resizes it's self when opened. I have tried
adjusting the width and height but I get an error message stating that the
values I am trying to change are Read Only!!

Could anyone offer any suggestions on how to do this if at all possible?

TIA,

Mark