How do you nz0 a text box in a report that has a null value 1

[rudolfelizabeth]

I have a report textbox, text33
the sourcecode is =[Beginbal] from a query

How do you nz 0 the beginbal value when the report is opened and beginbal is null

Private Subreport_open(cancel as interger)

Iff Beginbal = null , nz ([beginbal],0)
Endif
End sub

do you have to define the value Beginbal for the report
How.

 

[MazeWorX]

Use this as your source
=Nz([BeginBal],0)
untested

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]