Format event in reports (Access 2000)

Topic

New Reply

I have a report enumerating the invoices per customer.In the Format event
of the report i have put the condition that if the control called invoicenumber
is 0, then the control CompanyName must be red.I receive no error message
but the control CompanyName is not made red.
What is the error in my command ?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me![invoicenumber] = 0 Then
Me![CompanyName].ForeColor = 255
End If
End Sub

Reply | Quote

Replies

Try it in the Detail Print section instead.

BTW, why is it that an Invoice number of zero is allowed anyway?

Reply | Quote

Try it in the Detail Print section instead.

BTW, why is it that an Invoice number of zero is allowed anyway?

Reply | Quote

Like Pat wrote, do you really mean that the InvoiceNumber can be 0 (zero)? Or did you mean to check for an empty value (Null)?

Reply | Quote

Like Pat wrote, do you really mean that the InvoiceNumber can be 0 (zero)? Or did you mean to check for an empty value (Null)?

Reply | Quote