Moving Invisible Objects

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • layhan
    New Member
    • Feb 2009
    • 2

    Moving Invisible Objects

    I have a form with a list of OLE objects imported from Excel (they might as well be images or labels, doesn't matter.)

    Form_Current() is set up so when a check box is ticket (one for each object) they are visible or invisible

    If PropCD820 = vbChecked Then
    PriceCD820.Visi ble = False
    Else
    PriceCD820.Visi ble = True
    End If

    Simple enough.. the PROBLEM is to rearrange the visible ones to be one after the other (to avoid white space on the form.)

    Any suggestions? Like how to anchor them together when visible?

    I'm sure there's more than one way to do this, but any help is much appreciated.
  • ChipR
    Recognized Expert Top Contributor
    • Jul 2008
    • 1289

    #2
    I'm not sure what you can do with the objects, but if you were working with labels, you would just determine how many you needed, make that many visible from the top going down, and change the label captions to the ones that are visible. In effect, you just have placeholders.

    Comment

    • layhan
      New Member
      • Feb 2009
      • 2

      #3
      Thanks for your Reply but,the problem is that the objects (could also be labels) are visible only when you check a box (corresponding to that label) in a seperate form. So I have 10 check boxes corresponding to 10 labels. The checked ones become visible. The INvisible ones still take up space however.
      I need it to all be flush and not waste space (to then export it to pdf and print.)

      Can you help?

      Comment

      Working...