I’m trying to shrink some controls in Ms Access 2016 which are empty so that only the controls with data must be seen on the payroll summary. I have done the following:
1. Change label control to text box control so that the property CAN GROW/SHRINK can be applied on both sides.
2. I have also used this function to hide & unhide the controls depending to whether they contain some data or empty/null, Example
IIF ((PersonalLevy <> “”),” Personal Levy”, “”)
this code has replaced the label control and is working okay.
The white space still remains, that is what I DO NOT WANT to see, how can I remove it, the white space represents hidden controls. I have put both CAN GROW/SHRINK to YES
Any suggestion to remove it will be highly appreciated.