• Report (2003)

    Author
    Topic
    #430344

    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

    Viewing 0 reply threads
    Author
    Replies
    • #1004513

      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.

      • #1004520

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

        Thanks a lot.

        Regards

        • #1004566

          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

    Viewing 0 reply threads
    Reply To: Report (2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: