Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    18

    Question Unanswered: Access Move Blank Hidden Line Up

    In an Access 2000 report I am using

    Code:
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Text78 & "" = "" Then
    Label79.Visible = False
    Else
    Label79.Visible = True
    End If
    End Sub
    To hide blank text field labels. And it works fine.

    But how can I get the report to move that blank line up to fill in the blank?

  2. #2
    Join Date
    Nov 2005
    Posts
    18
    Using the code above and then set the property of the text box to can shrink did the trick.

Posting Permissions

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