ACCESS FEED: RE: [MS_AccessPros] 3 continuous subforms which will reposition and change size depending on data??

Rabu, 27 Juli 2011

RE: [MS_AccessPros] 3 continuous subforms which will reposition and change size depending on data??

Connie-

It can certainly be done, but I don't think you'll like the result if there are
multiple records in the outer form and the user can navigate to different
records. When the user moves to another row that has a different combination of
records in the three subforms, the screen will appear to "jump" as your code
resizes and moves the subform controls. Not attractive at all.

You basically will need to find out the number of records in each subform, set
the height to display only those records, then set the Top property of the
bottom two so they are appropriately aligned with no overlap. It might take
some trial-and-error, but it can be done.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Thursday, July 28, 2011 12:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] 3 continuous subforms which will reposition and change
size depending on data??

I don't want to try to do this if it's too crazy to try? Anybody else done it
and could help me?

Thanks!
Connie

------------------------------------

Yahoo! Groups Links