Solved Shrink Textbox

[sbaud2003]

I have several text boxes containing calculated data. Many of them will often be null or zero. How can I save space by making them go away unless there's something to show?

 

[theDBguy]

Hi. The only way I can think of is by using code or using one big Textbox and simply concatenate all results together as one. However, if you hide none results, wouldn't it confuse your users?

 

[Deleted member 147267]

Unless you can put all of these in a subform and shrink the section that contains it when there's no data, I don't see a simple solution. Whatever space you want to 'save' would be reclaimed when these controls do have data, so what happens to the things you put in the space that you 'saved'?

 

[sbaud2003]

Unless you can put all of these in a subform and shrink the section that contains it when there's no data, I don't see a simple solution. Whatever space you want to 'save' would be reclaimed when these controls do have data, so what happens to the things you put in the space that you 'saved'?

Thanks