I have a report with sub reports, one of the subreports have 12 text boxes
that are 2" high and I want them all to grow if one goes to 3" high.
If anyone has any suggestions they are very much appreciated.
Thanks
Edson Peacock 11 16174
> I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high.
You can't, because even if you were thinking about using Format event of
body section of your report, you may notice that the height of a control
is available only AFTER it is populated with values, so you cannot test when
it reaches 3" height.
You could try to control other aspects, like the lentgh of the value which
populates the textboxes, expecially if you are using a monotype font.
--
PBsoft di Gabriele Bertolucci www.pbsoft.it
skype: pbsoftsolution
thanks will tr to lengthen size of entry
Edson Peacock
"PBsoft" <in**@REMOVEpbsoft.it> wrote in message
news:87**************************@news.tin.it... I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high.
You can't, because even if you were thinking about using Format event of body section of your report, you may notice that the height of a control is available only AFTER it is populated with values, so you cannot test when it reaches 3" height.
You could try to control other aspects, like the lentgh of the value which populates the textboxes, expecially if you are using a monotype font.
-- PBsoft di Gabriele Bertolucci www.pbsoft.it skype: pbsoftsolution
On Thu, 11 May 2006 02:30:34 GMT, "Edson Peacock" <pe*********@mchsi.com>
wrote:
I assume that 12 text boxes 2 " high must be aligned horizontally.
If the boxes are all on one line: In the detail section, make the tops of all
boxes be the same and be greater than 0 (distance from top of section), height
= 2, and can grow = yes, and can shrink = no.
If the boxes are on multiple rows: Make the tops of the boxes in each row all
the same and at least .0007 below the bottom of the boxes above. height = 2.
can grow = yes, can shrink = no.
If one of the boxes above grows greater than 2, the entire row below will be
displaced down to clear the tallest box above.
Just a wizard prodder
Chuck
-- I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high.
If anyone has any suggestions they are very much appreciated.
Thanks
Edson Peacock
"Edson Peacock" <pe*********@mchsi.com> wrote in
news:W5D8g.143802$oL.68847@attbi_s71: thanks will tr to lengthen size of entry
Edson Peacock
"PBsoft" <in**@REMOVEpbsoft.it> wrote in message news:87**************************@news.tin.it... I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high.
You can't, because even if you were thinking about using Format event of body section of your report, you may notice that the height of a control is available only AFTER it is populated with values, so you cannot test when it reaches 3" height.
You could try to control other aspects, like the lentgh of the value which populates the textboxes, expecially if you are using a monotype font.
-- PBsoft di Gabriele Bertolucci www.pbsoft.it skype: pbsoftsolution
Is the real problem that the 12 boxes have borders and you need
to have all the borders the same height?
If it is, here's a solution: make the boxes unbordered, then, in
the Print Event of the section, find the box with the greatest
height, and use the line command to draw borders.
--
Bob Quintal
PA is y I've altered my email address.
Edson,
How do you know all the boxes are not growing at the same time? Mon, 15 May 2006 10:42:06 GMT, "Edson Peacock" <pe*********@mchsi.com> they are on the same line and i want them to all grow if one of them grows.
thanks in advance
Edson
On Thu, 11 May 2006 09:43:51 -0400, Chuck <li*****@schoollink.net> wrote:
On Thu, 11 May 2006 02:30:34 GMT, "Edson Peacock" <pe*********@mchsi.com> wrote:
I assume that 12 text boxes 2 " high must be aligned horizontally. If the boxes are all on one line: In the detail section, make the tops of all boxes be the same and be greater than 0 (distance from top of section), height = 2, and can grow = yes, and can shrink = no.
If the boxes are on multiple rows: Make the tops of the boxes in each row all the same and at least .0007 below the bottom of the boxes above. height = 2. can grow = yes, can shrink = no.
If one of the boxes above grows greater than 2, the entire row below will be displaced down to clear the tallest box above.
Just a wizard prodder Chuck
Chuck <li*****@schoollink.net> wrote in
news:nf********************************@4ax.com: Edson,
How do you know all the boxes are not growing at the same time?
You don't have to be Edson to know that horizontally allingned
text controls with can_grow set true will each grow to the
height determined by their contents. Using .borders will not
make a straight line across the row.. What has to be done is use
unbordered textboxes, and draw the lines in the section.print
event of the report.
Pseudocode
store 0 to variable.
for each control update variable if > current variable data.
draw horizontal line at control.top,
and at controlTop+ variable.
draw vertical lines at each control.left, and at
lastcontrol.left+lastleftcontrol.width Mon, 15 May 2006 10:42:06 GMT, "Edson Peacock" <pe*********@mchsi.com> they are on the same line and i want them to all grow if one of them grows.
thanks in advance
Edson
On Thu, 11 May 2006 09:43:51 -0400, Chuck <li*****@schoollink.net> wrote:
On Thu, 11 May 2006 02:30:34 GMT, "Edson Peacock" <pe*********@mchsi.com> wrote:
I assume that 12 text boxes 2 " high must be aligned horizontally. If the boxes are all on one line: In the detail section, make the tops of all boxes be the same and be greater than 0 (distance from top of section), height = 2, and can grow = yes, and can shrink = no.
If the boxes are on multiple rows: Make the tops of the boxes in each row all the same and at least .0007 below the bottom of the boxes above. height = 2. can grow = yes, can shrink = no.
If one of the boxes above grows greater than 2, the entire row below will be displaced down to clear the tallest box above.
Just a wizard prodder Chuck
--
Bob Quintal
PA is y I've altered my email address.
On Mon, 15 May 2006 21:48:00 GMT, Bob Quintal <rq******@sympatico.ca> wrote:
Bob,
I don't write code. Your pseudocode "looks" good.
At one time I could program in Basic, Pascal, and Frotran, but I haven't
written anything for a very long time.
I'm beginning to think that I didn't understand the original question
correctly.
I have a report that I have been using since 1998 that has 32 text boxes.
Four rows with eight to a row. The number of lines in each text box can vary
from zero to 14. All text boxes are set to height = 0.05 and both can grow and
can shrink = Yes. If text box number 3 has 14 lines while numbers
1,2,4,5,6,7,8 all have something less than 14 lines, then text boxes 9 thru 16
will all be displaced down so as to clear the bottom text box 3 and the tops of
boxes 9 thru 16 will all be in line with each other. Same result for boxes 17
thru 24 and boxes 25 thru 32. I have two horizontal lines. One above the top
row and one below the last row.
Just a wizard prodder
Chuck
-- Chuck <li*****@schoollink.net> wrote in news:nf********************************@4ax.com :
Edson,
How do you know all the boxes are not growing at the same time? You don't have to be Edson to know that horizontally allingned text controls with can_grow set true will each grow to the height determined by their contents. Using .borders will not make a straight line across the row.. What has to be done is use unbordered textboxes, and draw the lines in the section.print event of the report.
Pseudocode store 0 to variable. for each control update variable if > current variable data. draw horizontal line at control.top, and at controlTop+ variable. draw vertical lines at each control.left, and at lastcontrol.left+lastleftcontrol.width
Mon, 15 May 2006 10:42:06 GMT, "Edson Peacock" <pe*********@mchsi.com> they are on the same line and i want them to all grow if one of them grows.
thanks in advance
Edson
On Thu, 11 May 2006 09:43:51 -0400, Chuck <li*****@schoollink.net> wrote:
On Thu, 11 May 2006 02:30:34 GMT, "Edson Peacock" <pe*********@mchsi.com> wrote:
I assume that 12 text boxes 2 " high must be aligned horizontally. If the boxes are all on one line: In the detail section, make the tops of all boxes be the same and be greater than 0 (distance from top of section), height = 2, and can grow = yes, and can shrink = no.
If the boxes are on multiple rows: Make the tops of the boxes in each row all the same and at least .0007 below the bottom of the boxes above. height = 2. can grow = yes, can shrink = no.
If one of the boxes above grows greater than 2, the entire row below will be displaced down to clear the tallest box above.
Just a wizard prodder Chuck
Chuck <li*****@schoollink.net> wrote in
news:t8********************************@4ax.com: On Mon, 15 May 2006 21:48:00 GMT, Bob Quintal <rq******@sympatico.ca> wrote: Bob,
I'm beginning to think that I didn't understand the original question correctly.
If text box number 3 has 14 lines while numbers 1,2,4,5,6,7,8 all have something less than 14 lines, then text boxes 9 thru 16 will all be displaced down so as to clear the bottom text box 3 and the tops of boxes 9 thru 16 will all be in line with each other. Same result for boxes 17 thru 24 and boxes 25 thru 32. I have two horizontal lines. One above the top row and one below the last row.
That's fine. It's when trying to add vertical lines around the
various textboxes that the built-in borders fail. The vertical
lines to the left and right of box 3 will go down to line 14,
but box 1 may draw the lines to only the fourth line.
--
Bob Quintal
PA is y I've altered my email address.
the report is the proof one box has more info in it than another and
therefore is taller than the other 11 boxes
thanks
"Chuck" <li*****@schoollink.net> wrote in message
news:nf********************************@4ax.com... Edson,
How do you know all the boxes are not growing at the same time?
Mon, 15 May 2006 10:42:06 GMT, "Edson Peacock" <pe*********@mchsi.com> they are on the same line and i want them to all grow if one of them grows.
thanks in advance
Edson
On Thu, 11 May 2006 09:43:51 -0400, Chuck <li*****@schoollink.net> wrote:
On Thu, 11 May 2006 02:30:34 GMT, "Edson Peacock" <pe*********@mchsi.com> wrote:
I assume that 12 text boxes 2 " high must be aligned horizontally. If the boxes are all on one line: In the detail section, make the tops of all boxes be the same and be greater than 0 (distance from top of section), height = 2, and can grow = yes, and can shrink = no.
If the boxes are on multiple rows: Make the tops of the boxes in each row all the same and at least .0007 below the bottom of the boxes above. height = 2. can grow = yes, can shrink = no.
If one of the boxes above grows greater than 2, the entire row below will be displaced down to clear the tallest box above.
Just a wizard prodder Chuck
On Tue, 16 May 2006 02:53:39 GMT, Bob Quintal <rq******@sympatico.ca> wrote:
That is true about the vertical lines or borders. I didn't understand that the
text boxes had to outlined.
Just a wizard prodder
Chuck
-- Chuck <li*****@schoollink.net> wrote in news:t8********************************@4ax.com :
On Mon, 15 May 2006 21:48:00 GMT, Bob Quintal <rq******@sympatico.ca> wrote: Bob,
I'm beginning to think that I didn't understand the original question correctly.
If text box number 3 has 14 lines while numbers 1,2,4,5,6,7,8 all have something less than 14 lines, then text boxes 9 thru 16 will all be displaced down so as to clear the bottom text box 3 and the tops of boxes 9 thru 16 will all be in line with each other. Same result for boxes 17 thru 24 and boxes 25 thru 32. I have two horizontal lines. One above the top row and one below the last row.
That's fine. It's when trying to add vertical lines around the various textboxes that the built-in borders fail. The vertical lines to the left and right of box 3 will go down to line 14, but box 1 may draw the lines to only the fourth line.
On Tue, 16 May 2006 03:41:07 GMT, "Edson Peacock" <pe*********@mchsi.com>
wrote:
Edson,
If the boxes must be outlined, and all the outlines must be the same size
regardless of the amount of data in the boxes, then my suggestion will not
satisfy the requirements. You will have to write some code as Bob Quintal
suggested. On the other hand you could make all the boxes a fixed height of 3
inches. From what you have written, it appears that at least one of the 12
boxes is likely to require the 3 inches.
Somehow, I think that I still don't understand the original question properly.
If so, then the fault is mine, not yours. I've been told that I think
differently than everyone else.
Also see: http://www.lebans.com He has something there with complete code
about drawing vertical lines that grow. Then you will have to draw horizontal
lines tops and bottoms to complete the boxes.
Just a wizard prodder
Chuck
-- the report is the proof one box has more info in it than another and therefore is taller than the other 11 boxes
thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: dmiller23462 |
last post by:
Hi guys....I have absolutely NO IDEA what I'm doing with Javascript
but my end result is I need two text boxes to stay hidden until a
particular option is selected....I've cobbled together the...
|
by: Bob Sanderson |
last post by:
I have a form with several fields in-line in the detail. I am using the
borders of each text box to form a grid. The resultant output resembles a
spreadsheet. The problem I'm having is that in...
|
by: Mark |
last post by:
Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one...
|
by: ghadley_00 |
last post by:
Hi,
I have a report that has fields that grow/shrink. These reports each
have an image as a background. For records that cause the boxes to
shrink / grow I get a second page that only has the...
|
by: David Plotts |
last post by:
I'm a beginner with VB.net, only had one class in college on it.
I can't seem to remember how to add text boxes up.
I want to add the values in text boxes together, and put the value into a...
|
by: wrldruler |
last post by:
Hello,
I have a calendar report which uses 30 copies of a sub-report to build
each day. Working just fine except:
Let's say January 16th, there are 2 items to be listed for that date
and the...
|
by: Adel2007 |
last post by:
Hi everyone,
I have installed Stephan Leban's code to create a text box with a justified text in Access Report. This worked perfectly well. However, I need your help with regards to 2 problems:
1-...
|
by: noe1818 via AccessMonster.com |
last post by:
Just a quick question about lines:
Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to
txtbx3) with lines where txtbx1,2,&3 move up or down according to their
values? Like...
|
by: ofilha |
last post by:
I have created a report in design mode. However, some of the fields i need are dynamic. That is, i have a series of fields text boxes mostly that must show up only as needed. I also have some...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |