Hello All

I am working with MS Access reports. I have set Running Sum property to
"Over Group" for  a group and control source for one of the text box to
"=1". This sets the value of text box in sequential order. Now, I have to
intercept the value of this text box based on value of some other test box.
For Example. The values for text box for groups will be 1
..2..3...Blank...4...5. Is there a way to Set and Reset controlsource
property when the report is priniting.

Thanks
Ajay

Hi Ajay,
Have you tried the IIf function? It would work like this:
=Iif([textbox you want to check for a value]=(meets your 
criteria),"blank",=1)

HTH
Michael



> Hello All

I am working with MS Access reports. I have set Running Sum property to
"Over Group" for  a group and control source for one of the text box to
"=1". This sets the value of text box in sequential order. Now, I have to
intercept the value of this text box based on value of some other test box.
For Example. The values for text box for groups will be 1
..2..3...Blank...4...5. Is there a way to Set and Reset controlsource
property when the report is priniting.

Thanks
Ajay