Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old February 21st, 2006, 09:55 AM
Игорь
Guest
 
Posts: n/a
Default MS Access Reports

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




  #2  
Old February 21st, 2006, 07:45 PM
Stephen Lebans
Guest
 
Posts: n/a
Default Re: MS Access Reports

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.


"?????" <tsoy@otrs.ru> wrote in message
news:1140515004.265017.321220@o13g2000cwo.googlegr oups.com...[color=blue]
> Hello! There is a report containing strings with variable heights. Is
> it possible to count strings on each pages? Thanks.
>[/color]


  #3  
Old February 22nd, 2006, 07:35 AM
Игорь
Guest
 
Posts: n/a
Default Re: MS Access Reports

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.

  #4  
Old February 22nd, 2006, 08:45 PM
Stephen Lebans
Guest
 
Posts: n/a
Default Re: MS Access Reports

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.


"?????" <tsoy@otrs.ru> wrote in message
news:1140593222.168375.94220@o13g2000cwo.googlegro ups.com...[color=blue]
> 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.
>[/color]


  #5  
Old February 23rd, 2006, 09:25 AM
Igor
Guest
 
Posts: n/a
Default Re: MS Access Reports

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:[color=blue]
> 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.
>
>
> "?????" <tsoy@otrs.ru> wrote in message
> news:1140593222.168375.94220@o13g2000cwo.googlegro ups.com...[color=green]
> > 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.
> >[/color][/color]

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,414 network members.