I have a continuous form in Microsoft Access that has text boxes (Parts) that are stacked one on top of the other in the form.
I want blank text boxes to hide and move the next text box which has data to top leaving no empty rows inbetween
Novice
Windows 10 
Access 2019
I have a continuous form in Microsoft Access that has text boxes (Parts) that are stacked one on top of the other in the form.
I want blank text boxes to hide and move the next text box which has data to top leaving no empty rows inbetween
Competent Performer
Windows 10 Office 365
I'm afraid this is only possible with reports, using the Can Shrink feature.
VIP
Windows 10 Office 365
Those records should be child records in a sub form, then you would only see them when they existed?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Virtually Inert Person
Windows 10 Access 2016
True about the subform. I'd say that these are repeating type fields in the same table as the customer data, which would be wrong.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 10 Access 2019
Thank you for the reply. I will create a subform and check.
How to make unbound text boxes display values from a table that isn't the data source
Bound text box in a form to display empty when opened
Auto populate multiple text boxes and combo box in continuous form
Posting Permissions
Reply With Quote