Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format event in reports (Access 2000)

    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

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Format event in reports (Access 2000)

    Try it in the Detail Print section instead.

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

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format event in reports (Access 2000)

    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)?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •