Results 1 to 4 of 4

Thread: Report (2003)

  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report (2003)

    Hi,

    I have about 10 input fields in the form to let user to enter information, but no all 10 fields are required to input. Maybe one time only 5 fields or 7 fields. After user finish enter information they will run the report to show the information they just enter.

    Is anyway the report only show the field they enter not all of the 10 fields?

    Thanks

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

    Re: Report (2003)

    You could put code in the On Format event of the detail section of the report (if the text boxes are in that section) to set the Visible property of text boxes to No if the value is null.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report (2003)

    Yes. The text boxes are in the deatail section of the report. Can you provide the code with sample?

    Thanks a lot.

    Regards

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

    Re: Report (2003)

    Code would look like this, with the appropriate names substituted:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.txtThis.Visible = Not IsNull(Me.txtThis)
    Me.txtThat.Visible = Not IsNull(Me.txtThat)
    ...
    End Sub

Posting Permissions

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