If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do make a TextBox not display in an Access report when it is .
I have a report with two TextBoxes that I use to display information from a
table. Often in the report, one or the other (or both) of the controls are emplty (i.e., no data is returned from the Table. I would like the report not to display the Label of the TextBox in those situations. |
#2
|
|||
|
|||
How do make a TextBox not display in an Access report when it is .
Change the label to a text box (right-click it.)
Put an expression in the Control Source of this text box so it is null when the main one is null. For example, if you want it to show "City:" only when the City text box has a value, use: =IIf([City] Is Null, Null, "City:") -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Larry M" Larry wrote in message ... I have a report with two TextBoxes that I use to display information from a table. Often in the report, one or the other (or both) of the controls are emplty (i.e., no data is returned from the Table. I would like the report not to display the Label of the TextBox in those situations. |
Thread Tools | |
Display Modes | |
|
|