problem accessing formula field with visual basic 1

[bartvb]

What i do get is the name: (debugging mode)

?report.FormulaFields.Item(1).Name
{@amountofdata}

So the formula field excists !

What doesn't work

?report.FormulaFields.Item(1).value

=> gives empty value although when i show the report on the screen a value is printed !?

Does anyone know a solution to my problem?

*******************************************
I'm trying to use the formula to see wheter there is data in the report =>

If IsNull (Count({INTERN.NAAM_STUDENT})) then
0
else
Count ({INTERN.NAAM_STUDENT})

And so I don't want to show the report if the formula field is null?

Is there another way to hide the report if it's emty ??

Thanx, Bart !

 

[vdpras]

I think , checking 'suppress printing if no Records' option in Report Options should work.

Prasanna