Report Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This code works ok if i have records in the tbl ,,when the tbl is empty i get an error Expression with NoValue and this points to my firstline of cod
I have tried Nz and this does not wor
Any ideas pleas

If ([GST] = 0) The
Me!InvoiceLabel.Caption = "Invoice
Me!TotalIncludingGST.Caption = "Total
Els
Me!InvoiceLabel.Caption = "Tax Invoice
Me!TotalIncludingGST.Caption = "Total Inc GST
End If
 
Back
Top