By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,122 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,122 IT Pros & Developers. It's quick & easy.

Moving Invisible Objects

P: 2
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.Visible = False
Else
PriceCD820.Visible = 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.
Feb 4 '09 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,287
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.
Feb 4 '09 #2

P: 2
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?
Feb 4 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.