Hi all,
I have a frmFormFilters that i use as a template as a subform for most of my forms. When it loads it Dlookups the parent form name in tblFormFilters and if a checkbox is true in the table it sets the visible property to true on the frmFormFilter for. (esentially tells the form holding the report which criteria is applicable to that report.
I am running into layout issues. because the form is a template it is always set up something like:
lblFromDate txtFromDate
lblDivision txtDivision
lblTruck txtTruck
When i have the correct filters showing for the form it ends up looking like:
lblFromDate txtFromDate
lblTruck txtTruck
I want to do a stacked layout on the controls if they are visible so they line up one after another and remove the empty spaces where there is a control hiding.
thanks for any help
I have a frmFormFilters that i use as a template as a subform for most of my forms. When it loads it Dlookups the parent form name in tblFormFilters and if a checkbox is true in the table it sets the visible property to true on the frmFormFilter for. (esentially tells the form holding the report which criteria is applicable to that report.
I am running into layout issues. because the form is a template it is always set up something like:
lblFromDate txtFromDate
lblDivision txtDivision
lblTruck txtTruck
When i have the correct filters showing for the form it ends up looking like:
lblFromDate txtFromDate
lblTruck txtTruck
I want to do a stacked layout on the controls if they are visible so they line up one after another and remove the empty spaces where there is a control hiding.
thanks for any help
