Change the height of ONLY the current/selected record in a MULTIPLE ITEMS form w/ VBA

[dkmort]

Anybody know whether this is possible? I think I had tried it in the past, but it changed the height of EVERY record, rather than just the one I had selected. If you know an answer to this (whether it can or cannot be done), I would appreciate any input.

Cheers!

-
Doug Mortensen

 

[boblarson]

It cannot be done on a form's Continuous or Datasheet view.

 

[exebat]

You could create a form with 3 subforms.

It would look look like this:

Small size form with records before the big one:
----------------------------------------
InvNmb CustName InvAmount
----------------------------------------

The big form with all the fields



You could create a form with 3 subforms.

It would look look like this:

The same small form from the top with records after the big one:
----------------------------------------
InvNmb CustName InvAmount
----------------------------------------


What you should do is to set the OnCurrent event of the small forms to point the big one to the same record, and the big one OnCurrent event to filter the small forms in the following way:

The first one should show all the records smaller then the big form, and the second one should show all the records bigger then the one on the big form.

If you design it appropriately it would look like the form records resize on current record.

 

[dkmort]

Hmm. That's an interesting idea. I'll keep it in mind. I may very well use it. But it will probably take me at least a few hours to implement it. I like the idea though. Just when you think that you simply may not be able to do something, someone else points out a "different" way that it can actually be done!

Thanks again!
-
Doug