MS Access Reports

[Игорь]

Hello! There is a report containing strings with variable heights. Is
it possible to count strings on each pages? Thanks.

[Stephen Lebans]

It is but not in a simple straightforward maner. What exactly are you tring
to accomplish?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"?????" <ts**@otrs.ru> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hello! There is a report containing strings with variable heights. Is
it possible to count strings on each pages? Thanks.

[Игорь]

The report contains report header section, details section and report
footer section.
Data string contains field(s) with variable height(s) (the height
depends on length of text string).
Terms:Every pages (including pages with header and footer sections)
must contain 1 data string minimum.

[Stephen Lebans]

There is obviously a language issue here. If I understand you correctly,
even if there is no data in the current row, you want the all of the TextBox
controls to be sized to display one row of text.
In the Format event of the Detail section, you could check and see if the
current value of the TextBox contrl(s) is empty. If so then programmatically
resize all of the TextBox controls in this section to a specific height.

If Me.NameOfTextBox1.Value = "" then Me.TextBox1.Height = 1440/10

THis would size the TextBox to a 1/10 of an inch in height. You would
obviously adjust the number as required. Access control dimensions are
specified at run time in TWIPS. There are 1440 TWIPS per inch.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"?????" <ts**@otrs.ru> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

The report contains report header section, details section and report
footer section.
Data string contains field(s) with variable height(s) (the height
depends on length of text string).
Terms:Every pages (including pages with header and footer sections)
must contain 1 data string minimum.

[Igor]

I'm sorry, I badly express. The problem was in that to print at least 1
row on last page (The height every row can be various). I have found
the decision of the problem, nevertheless, thanks a lot.

Igor Tsoy

Stephen Lebans wrote:

There is obviously a language issue here. If I understand you correctly,
even if there is no data in the current row, you want the all of the TextBox
controls to be sized to display one row of text.
In the Format event of the Detail section, you could check and see if the
current value of the TextBox contrl(s) is empty. If so then programmatically
resize all of the TextBox controls in this section to a specific height.

If Me.NameOfTextBox1.Value = "" then Me.TextBox1.Height = 1440/10

THis would size the TextBox to a 1/10 of an inch in height. You would
obviously adjust the number as required. Access control dimensions are
specified at run time in TWIPS. There are 1440 TWIPS per inch.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"?????" <ts**@otrs.ru> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

The report contains report header section, details section and report
footer section.
Data string contains field(s) with variable height(s) (the height
depends on length of text string).
Terms:Every pages (including pages with header and footer sections)
must contain 1 data string minimum.