draw line in mid page

[kok0kok]

I want draw line in mid report page for this condithion :

if count(myfield) < 15

or ( group page rowes less than 15 row )

and start new page under this line ? ;-)

 

[kok0kok]

i want remove mid line from page 3 because in page 3
Contain 45 row if page 3 Contain 15 row or less i don't want remove this line ok

 

[dhookom]

My understanding is you want to remove the line from page 3 because it contains 45 rows.

Apparently you don't want a line on a page that displays less than 15 rows. I'm not sure this can be accomplished in the On Page event.

Perhaps if we knew how your data is paged and/or grouped there might be a solution.

Duane
Hook'D on Access
MS Access MVP

 

[kok0kok]

bravo
my table data same this and my group report with field "dast"

fldPers;flsShSh;tsfg;dast;fldNEst;fldTEst;fldShHe

4030 N 47787 3 4 47787 47787
4010 rrrrr 47787 3 1 47787 47787
4030 TGHFJ 41841 3 4 41841 41841
4010 MMMMM 41941 3 1 41941 41941
4010 kkkkk 47787 3 10 47787 47787
4030 HGJ 47787 3 4 47787 47787
4010 NVHNV 47791 3 1 47791 47791
4030 F 41841 3 4 41841 41841
4010 kkkkk 47787 3 1 47787 47787
4010

http://WWWWW

47789 4 10 47789 47789
4030 BG 47787 4 4 47787 47787
4010 IIIII 40355 4 1 40355 40355
4030 JNGH 47787 4 4 47787 47787
4010 iiiii 40355 4 1 40355 40355
4010 DSSSS 41841 4 1 41841 41841
4031 RTE 41939 4 5 41939 41939
4010 CC 40144 4 1 40144 40144
4010 HFG 40355 4 1 40355 40355
4010 zzzzz 41841 4 1 41841 41841
4030 XC 41841 4 4 41841 41841
3116 hhhhh 03045 4 7 03045 03045
4031 JHG 41939 4 5 41939 41939
4030 GH 41941 4 4 41941 41941
4030 B 41841 4 4 41841 41841
4030 CVB 47787 5 4 47787 47787
4010 FHNJG 03266 5 6 03266 03266
4010 52497 47789 5 1 47789 47789
4010 G 03266 5 6 03266 03266
4010 FHGFH 03012 5 6 03012 03012
4010 FGHFG 41841 5 1 41841 41841
4010 GH 03266 5 6 03266 03266
4010 HFGHF 03266 5 6 03266 03266
4010 GFG 40144 5 1 40144 40144
4010 B C 03091 5 6 03091 03091
4010 bbbbb 41841 5 1 41841 41841
3007 bbbb 03010 5 6 03010 03010
3090 ddddd 03104 5 7 03104 03104
3091 eeeee 02035 5 6 02035 02035
3115 hhhhh 03039 5 7 03039 03039
3116 jjjjj 03076 5 6 03076 03076
4042 rrrrr 47791 5 12 47791 47791
4010 yyyyy 47787 5 1 47787 47787
4010 ppppp 41849 5 1 41849 41849
4010 PPPPP 03268 5 6 03268 03268
4010 vvvvv 47787 5 1 47787 47787
4010 EREFG 03267 5 6 03267 03267
4010 lllll 47789 5 1 47789 47789
4010 uuuuu 47787 5 1 47787 47787
4010 ttttt 47775 5 10 47775 47775
4010 EEEEE 47789 5 10 47789 47789
4010 RRRRR 40355 5 10 40355 40355
4010 UUUUU 03131 5 6 03131 03131
4030 BCV 41841 5 4 41841 41841
4010 DFFFF 41841 5 1 41841 41841
4010 XCCCC 41841 5 1 41841 41841
4010 qqqqq 03267 5 6 03267 03267
4030 V 40355 5 4 40355 40355
4030 V 40355 5 4 40355 40355
4030 FDSFD 40144 5 4 40144 40144
4031 F 41849 5 5 41849 41849
4031 ERF 41939 5 5 41939 41939
4031 H 49360 5 5 49360 49360
4031 JK 41939 5 5 41939 41939
4031 06818 41939 5 5 41939 41939
4030 XCV 41939 5 4 41939 41939
4031 K 41939 5 5 41939 41939
4030 CX 47787 5 4 47787 47787
4030 V 47787 5 4 47787 47787
4030 VCX 40144 5 4 40144 40144
3000 aaaa 03010 5 6 03010 03010
4031 JH 41939 5 5 41939 41939
4031 F 40279 6 8 40279 40279
4031 DFG 40467 6 4 40467 40467
4031 H 41939 6 5 41939 41939
4031 KH 40144 6 4 40144 40144
4031 HJ 40418 6 10 40418 40418
4031 GHJNG 41841 6 4 41841 41841
4031 H 41534 6 4 41534 41534
4031 K 01009 6 4 01009 01009
4031 FH 44274 6 4 44274 44274
4031 HK 48016 6 4 48016 48016
.
.
.

 

[kok0kok]

or this

fldPers,flsShSh,tsfg,dast,fldNEst,fldTEst,fldShHe

4030,N,47787,3,4,47787,47787
4010,rrrrr,47787,3,1,47787,47787
4030,TGHFJ,41841,3,4,41841,41841
4010,MMMMM,41941,3,1,41941,41941
4010,kkkkk,47787,3,10,47787,47787
4030,HGJ,47787,3,4,47787,47787
4010,NVHNV,47791,3,1,47791,47791
4030,F,41841,3,4,41841,41841
4010,kkkkk,47787,3,1,47787,47787
4010,

http://WWWWW,47789,4,10,47789,47789

4030,BG,47787,4,4,47787,47787
4010,IIIII,40355,4,1,40355,40355
4030,JNGH,47787,4,4,47787,47787
4010,iiiii,40355,4,1,40355,40355
4010,DSSSS,41841,4,1,41841,41841
4031,RTE,41939,4,5,41939,41939
4010,CC,40144,4,1,40144,40144
4010,HFG,40355,4,1,40355,40355
4010,zzzzz,41841,4,1,41841,41841
4030,XC,41841,4,4,41841,41841
3116,hhhhh,03045,4,7,03045,03045
4031,JHG,41939,4,5,41939,41939
4030,GH,41941,4,4,41941,41941
4030,B,41841,4,4,41841,41841
4030,CVB,47787,5,4,47787,47787
4010,FHNJG,03266,5,6,03266,03266
4010,52497,47789,5,1,47789,47789
4010,G,03266,5,6,03266,03266
4010,FHGFH,03012,5,6,03012,03012
4010,FGHFG,41841,5,1,41841,41841
4010,GH,03266,5,6,03266,03266
4010,HFGHF,03266,5,6,03266,03266
4010,GFG,40144,5,1,40144,40144
4010,B C,03091,5,6,03091,03091
4010,bbbbb,41841,5,1,41841,41841
3007,bbbb,03010,5,6,03010,03010
3090,ddddd,03104,5,7,03104,03104
3091,eeeee,02035,5,6,02035,02035
3115,hhhhh,03039,5,7,03039,03039
3116,jjjjj,03076,5,6,03076,03076
4042,rrrrr,47791,5,12,47791,47791
4010,yyyyy,47787,5,1,47787,47787
4010,ppppp,41849,5,1,41849,41849
4010,PPPPP,03268,5,6,03268,03268
4010,vvvvv,47787,5,1,47787,47787
4010,EREFG,03267,5,6,03267,03267
4010,lllll,47789,5,1,47789,47789
4010,uuuuu,47787,5,1,47787,47787
4010,ttttt,47775,5,10,47775,47775
4010,EEEEE,47789,5,10,47789,47789
4010,RRRRR,40355,5,10,40355,40355
4010,UUUUU,03131,5,6,03131,03131
4030,BCV,41841,5,4,41841,41841
4010,DFFFF,41841,5,1,41841,41841
4010,XCCCC,41841,5,1,41841,41841
4010,qqqqq,03267,5,6,03267,03267
4030,V,40355,5,4,40355,40355
4030,V,40355,5,4,40355,40355
4030,FDSFD,40144,5,4,40144,40144
4031,F,41849,5,5,41849,41849
4031,ERF,41939,5,5,41939,41939
4031,H,49360,5,5,49360,49360
4031,JK,41939,5,5,41939,41939
4031,06818,41939,5,5,41939,41939
4030,XCV,41939,5,4,41939,41939
4031,K,41939,5,5,41939,41939
4030,CX,47787,5,4,47787,47787
4030,V,47787,5,4,47787,47787
4030,VCX,40144,5,4,40144,40144
3000,aaaa,03010,5,6,03010,03010
4031,JH,41939,5,5,41939,41939
4031,F,40279,6,8,40279,40279
4031,DFG,40467,6,4,40467,40467
4031,H,41939,6,5,41939,41939
4031,KH,40144,6,4,40144,40144
4031,HJ,40418,6,10,40418,40418
4031,GHJNG,41841,6,4,41841,41841
4031,H,41534,6,4,41534,41534
4031,K,01009,6,4,01009,01009
4031,FH,44274,6,4,44274,44274
4031,HK,48016,6,4,48016,48016
.
.
.

 

[dhookom]

You still haven't explained your report and requirements.

Let's assume there is no way during the Page event to determine how many records will be printed on the current page.

You might be able to use some other information about your report such as no page will display more than one [dast] value. It also important to know if the detail section will ever grow.

Duane
Hook'D on Access
MS Access MVP

 

[MichaelRed]

If these are "groups" in the std report, just put a line in the group footer/.

Not sure if you want a new page after each group, or just a page no change. The latter doesn't compute for me, but the former is just a "page break" control in the group header / footer.

MichaelRed

 

[kok0kok]

[COLOR=red yellow] what offer to me ? [/color]