Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Shrinking Text Boxes
I feel really silly. Turns out I had a vertical line that was interfering with the formatting. turns out the =IIf([State]="Michigan","",[State]) or the =IIf([State]="Michigan",Null,[MyDataSource]) work just as well. As long as the "Can Shrink" property...- hnoon
- Post #4
- Forum: Microsoft: Access Reports
-
Shrinking Text Boxes
I'm not sure what you mean by horizontal/vertical. Let me try and explain what I meant a bit better. Say I want to place an address somewhere in my report. The textboxes present are going to be (arranged one on top of the other): Name Address City State There are other elements present in the...- hnoon
- Post #3
- Forum: Microsoft: Access Reports
-
Shrinking Text Boxes
What criteria does MS Access use to Shrink a text box? I want to Shrink a text box if a certain condition is met, else go ahead and show it. I would imagine it should work with something like this in the Text Box Control Source: =IIf(<Shrink Condition Goes Here>,"",[MyDataSource]) I...- hnoon
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
