Fill Back Color Of A Continuous Form?

[b-ballstyle]

Hello,

I have this continuous form and I'm trying to continue the alternated colors even if there is no more records to show. As of now, at the middle when there is no more records, only the grey back color continue to display but I want the alternation to continue..

Is it possible?

 

[b-ballstyle]

Sorry we cant really see the difference in the colors.. Here's an update !

 

[vbaInet]

It can't alternate when there are no more records present. If you want this type of setting then I would suggest you use Excel.

I have an example of creating fixed number of rows for reports using subreports so the same concept should apply here. But then again it will require more code to get the alternating colours to be in synch. Too much hassle to be honest.

 

[b-ballstyle]

Well, this is a subform and i was trying to make it more professional by filling those alternated colors even if there is no records

 

[vbaInet]

I would just make it white. Alternating colours in sections where there is no data would give the wrong impression and confuse your users.

 

[b-ballstyle]

No, I think its better with the alternation because without it it looks just like a rectangle.. Have a look