=IIf([txtCnt]=6, " Grand Total = " &[txtGrandTotal],Null).

[bigmax98]

It only display "Grand Tot". I lost the rest.
How do display everything without choping off my statement.

Thanks

 

[eydata]

hi

nedd space between '&' and '[txtGrandTotal]' as shwon below:
IIf([txtCnt]=6, " Grand Total = " & [txtGrandTotal],Null)

 

[straybullet]

Also, extend the length of the textbox to the right.

Let them hate - so long as they fear... Lucius Accius