Result shows when printed but not in Report View

[crimedog]

I have a TextBox with :

=IIf(DCount("*","[QuryRepQtrBonus]")>0,DSum("[QtrBonus]","[QuryRepQtrBonus]"),0)

In Report View - the box appears blank - UNLESS you click it.
When Printed: the result shows in the box no problem

I would like it to show in report view (even if there is a delay for calculation)

[Homegrownandy]

Where did you put that code? put it on the form load event and see if that does it.

[crimedog]

looks like It will work putting it into On Load - but how do you translate formula with quotes into vba
I want

Me.RevAttain1.Controlsource = "DLookUp("[RevBonus]","[Tbl2_MgrBonus]","[BonusMo]=" & [TxtMo1] & "And [BonusYr]=" & [TxtYear] & "And [MgrID]=" & [TxtMgrID])"

It hits the first quote and thinks it is the end of the expression. If I triple up the quotes it does not work

Me.RevAttain1.Controlsource  ="DLookUp("""[RevBonus]""","""[Tbl2_MgrBonus]""","""[BonusMo]=""" & [TxtMo1] & """And [BonusYr]=""" & [TxtYear] & """And [MgrID]=""" & [TxtMgrID])"

[crimedog]

I am going to ask this in Programming section.

[Homegrownandy]

That's too complicated for me mate