Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report label (Access 2000)

    Can you help me make visible the label "performance level" in my report, only when the text box called "performancelevel" shows some value.And also is it possible to shrink the space , when there is nothing in the labels and the textbox "performancelevel?

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

    Re: Report label (Access 2000)

    Make sure that the label is attached to the text box. You can check as follows: if you select the text box, you should see a little black square in the upper left corner of the label. If not:
    - Select the label
    - Press Ctrl+X to cut the label.
    - Select the text box.
    - Press Ctrl+V to paste the label as an attached label.

    Set the Can Shrink property of the text box to Yes, and do the same for the Detail section of the report.

    Create an event procedure for the On Format event of the detail section:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.[PerformanceLevel].Visible = Not IsNull(Me.[PerformanceLevel])
    End Sub

    Replace PerformanceLevel with the actual name of the text box.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report label (Access 2000)

    Just to let you know that your suggestion is perfect !
    Please accept my best wishes

    Freelance

Posting Permissions

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