Literally just 2-weeks ago I applied similar functionality to forms in an Access database I was asked to work on.

For the most part, I actually followed the same steps as Richard in both the free and extended versions of this video. The most significant difference I had was in steps for positioning visible fields when one or more was shown or hidden.

Note: This technique isn't one everyone will like, but the "Legos" are already in the Access Toy Chest so once in a while, I dig 'em out and play with them, lol.

If you're willing to work with less popular features, you can use a "tabbed layout" to align your fields. When working in Design View, if you resize a field that's part of a layout, all other fields in the same row or column will resize to accommodate. This functionality also works at runtime when you change the size of a field with VBA.

So, when you change "FirstName" to "Visible=False" and "Width=0", all remaining fields to the right will automatically move left to fill in remaining space. Likewise, when you make it visible again and restore its width, the other fields will automatically move and make room.

The other nice thing is that it adjusts the whole column so you don't have to worry about moving labels in the heading or totals in the footer (if your layout covers all 3 sections).

The one thing to consider if you decide to try this technique is that, even if they are set to "transparent", the gridlines will take up space between your fields. How much depends on the width setting of the gridlines on each side of each control in the grid. But, once you've worked with them, it's fairly easy to handle. Also, while "borders" will automatically be hidden when a field's visibility is set to "no", if you have them visible, you have to manually toggle the setting for each side for gridlines as they are separate from the control.

As I said above, not everyone's cup of tea, but as Richard says there's always more than one way to do just about anything in Access so I thought I'd share and alternate method if anyone's interested.