Hide / collapse columns in Form as needed
Posted on 2013-01-07
I am using Access 2010. This question is about a continuous form. The underlying table accepts movement of inventory from source to destination.
When the user opens the form, he/she will use an unbound combobox to choose whether the data entry will reflect items sold or items transferred. If the user chooses "transfer", then there is no need to enter information in some fields... ie [price], [discount] etc.
In such cases (user has chosen "transfer"), I would like the unwanted fields to disappear. That is easy enough. I also want to collapse the empty space so that the resultant form does not look like a patchwork quilt. It would be great if I could put these fields on the outermost right of the form, but this is not possible. I would like to emulate the way that Excel does it when you hide a column.
At this time, the best that I can come up with is to make them invisible, set their width to one pixel and move all the other columns next to the invisible column. I haven't tried this yet. It seems like a complex way to solve a simple problem.
I really would like to perform both tasks in one form. Is there a better way?