Shifting fields left on a continuous form

 I have a field on a continuous form that is only occasionally visible.  Yet, when visible, I'd like it to be right next to another field.   And I don't want to leave an ugly gap in the middle.   See Shifting fields left on a continuous form in Microsoft Access

Added: I"ve added David W Fenton's comments and links to a discussion and sample code to the above web page.

Published Mon, Nov 12 2007 23:14 by Tony
Filed under: , ,

Comments

# re: Shifting fields left on a continuous form

While it's not such a big deal for the situation you describe, I find it much more efficient when looping through controls to do things to them to define custom collections. That way, you loop through the whole controls collection only once each time you open the form instance, and each other traversal is of a much smaller collection specific to your needs. I found that this approach noticeably enhances performance.

Of course, that only really matters when you're altering controls often during a single form sessions, e.g., enabling/disabling groups of controls based on a record type. In that situation, it really does help a lot.

Tuesday, November 13, 2007 4:45 PM by David W. Fenton

Leave a Comment

(required) 
(required) 
(optional)
(required) 
If you can't read this number refresh your screen
Enter the numbers above: