If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Move Rows up to Blank Area. Plz Help
I have tones of other fields in the detail section besides this portion. This
is a demographical section they wanted me to add to an existing report. It is set up correctly except for the rows not moving up to take the place of other rows where the option box has not been selcted. I have heard everything from can shrink to do it in the query to????? I am lost as how to get these to move up. They are 5 coloumns accross and 5 rows down. Any other ideas would be helpful and thanks again to all that is trying to help me on this one. "krissco" wrote: On Jul 12, 12:06 pm, TKM wrote: Krissco, OK so what does this do. I added it into onformat and it does nothing so I guess that is good? Thanks gain and please advise what I should do next. The code will show/hide the detail section based on criteria. When it is hidden, instead of printing a "blank row" of data - the report will print nothing. Upon formatting the next non-null row, the section will be marked visible and will print. -Kris |
#13
|
|||
|
|||
Move Rows up to Blank Area. Plz Help
By using criteria in your query for the report the "row" is never developed,
so if it never existed then any results afterwards is automatically moved up. What is the Record Source for your report? -- KARL DEWEY Build a little - Test a little "TKM" wrote: I forgot to mention I dont see how an entire row or rows can move up and replace an entire row in a report. How would this work? How can the valid rows move up to take the null rows place. I am at a hugh LOSS! "KARL DEWEY" wrote: Why not just add criteria in the query? -- KARL DEWEY Build a little - Test a little "TKM" wrote: I EXPLAINED IT WRONG ON MY OTHER LISTING! I have a report that has several rows and colunms as follows. I have it set up if a check box is true to show the entire Row or Rows for each Column. What I need now is, if row 2 is null (all blank) I want row 3 and row 4 to move up into row 2's position so it will not show a blank where row 2 once was. How do I get the entire row that is True to move up and take its place? EXAMPLE: ............Column 1.......Column 2.......Column 3..........colunm 4 1................0.99............1.34............. .66.6................5.55 2. ................I want row 3 an 4 to move up to this position....... 3.................00.34........3.44............... 0.34.................6.77 4.................0.64...........1.23............. .22.89..................0.9 |
#14
|
|||
|
|||
Move Rows up to Blank Area. Plz Help
On Jul 12, 1:52 pm, KARL DEWEY
wrote: By using criteria in your query for the report the "row" is never developed, so if it never existed then any results afterwards is automatically moved up. What is the Record Source for your report? -- KARL DEWEY Build a little - Test a little Thats wonderfully simple - no wonder why I didn't think of it! -Kris |
#15
|
|||
|
|||
Move Rows up to Blank Area. Plz Help
Where is the checkbox relative to the textboxes in each row? Is the 1, 2, 3,
4 your numbers for reference or are they part of the data? Are they also textboxes? PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "TKM" wrote in message ... Steve, I have text boxes like.the following.If a check box is null and it is accosiated with line two (a check box makes the 4 other text boxes visible or not). I want row 3 and 4 to move into number 2's position. Each one of the below is a text box. Does that help? ............year to.......year from.......one-mile..........five mile 1................0.99............1.34............. .66.6................5.55 2. ................I want row 3 an 4 to move up to this position....... 3.................00.34........3.44............... 0.34.................6.77 4.................0.64...........1.23............. .22.89..................0.9 "Steve" wrote: Do you have anything to the left or right of the rows. Can shrink won't work if there is anything there. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "TKM" wrote in message ... Steve, I set all of my Text boxes to YES on can shrink. Nothing happends. I set the option box and all of the text boxes associated with the option box. I still have a blank where row 2 use to be and row 3 and 4 are below it. Any other ideas? Thank you for your help!"Steve" wrote: On your report, select the textbox for Column 1. Open properties and go to the Format tab. Set Can Shrink to Yes. Do the same for the textboxes for Volumn 2 to Column 4. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "TKM" wrote in message ... I EXPLAINED IT WRONG ON MY OTHER LISTING! I have a report that has several rows and colunms as follows. I have it set up if a check box is true to show the entire Row or Rows for each Column. What I need now is, if row 2 is null (all blank) I want row 3 and row 4 to move up into row 2's position so it will not show a blank where row 2 once was. How do I get the entire row that is True to move up and take its place? EXAMPLE: ............Column 1.......Column 2.......Column 3..........colunm 4 1................0.99............1.34............. .66.6................5.55 2. ................I want row 3 an 4 to move up to this position....... 3.................00.34........3.44............... 0.34.................6.77 4.................0.64...........1.23............. .22.89..................0.9 |
|
Thread Tools | |
Display Modes | |
|
|