How to add "No Mailing Address" to Directory

Michele Thompson 2

Good morning!

I am trying to update our Directory Listing Report that was created by my predecessor. I am totally stumped as to how she did something and am trying to "recreate" for another line. If there is not a mailing address on file, she seems to just have a text box over the fields that says No Mailing Address on File. I have not idea how it knows to put it only on those. I can't seem to connect it to a subreport or a formula. My communications department wants me to be able to change it so that if there is No Mailing Address and No Email Address on file that it says No Mailing or Email Address on File. I tried to do a copy and paste of the text box to the next line for the email, but if someone has a phone, it puts it over the phone number. I would have thought she would have created a formula, but it is not. I tried to capture it below. You can see the text box over the GH2B. Any suggestions? I am stumped....Thank you!!!



Michele

Marie Stark

Michele Thompson:

Good morning!

I am trying to update our Directory Listing Report that was created by my predecessor. I am totally stumped as to how she did something and am trying to "recreate" for another line. If there is not a mailing address on file, she seems to just have a text box over the fields that says No Mailing Address on File. I have not idea how it knows to put it only on those. I can't seem to connect it to a subreport or a formula. My communications department wants me to be able to change it so that if there is No Mailing Address and No Email Address on file that it says No Mailing or Email Address on File. I tried to do a copy and paste of the text box to the next line for the email, but if someone has a phone, it puts it over the phone number. I would have thought she would have created a formula, but it is not. I tried to capture it below. You can see the text box over the GH2B. Any suggestions? I am stumped....Thank you!!!



Michele

It might have a suppression formula in the text box that causes not to show if there there is no address.  You can try right clicking on the tex box, select Format Text, and open the box yo the right of "Suppress" and see if there is a formula there.

Michele Thompson 2

Marie Stark:

Michele Thompson:

Good morning!

I am trying to update our Directory Listing Report that was created by my predecessor. I am totally stumped as to how she did something and am trying to "recreate" for another line. If there is not a mailing address on file, she seems to just have a text box over the fields that says No Mailing Address on File. I have not idea how it knows to put it only on those. I can't seem to connect it to a subreport or a formula. My communications department wants me to be able to change it so that if there is No Mailing Address and No Email Address on file that it says No Mailing or Email Address on File. I tried to do a copy and paste of the text box to the next line for the email, but if someone has a phone, it puts it over the phone number. I would have thought she would have created a formula, but it is not. I tried to capture it below. You can see the text box over the GH2B. Any suggestions? I am stumped....Thank you!!!



Michele

It might have a suppression formula in the text box that causes not to show if there there is no address.  You can try right clicking on the tex box, select Format Text, and open the box yo the right of "Suppress" and see if there is a formula there.

 

Thanks, Marie. I checked that. The box wasn't checked but there is a formulat that says No Valid Address = False. 

Alan French

If the Suppress box is checked, the object will be suppressed all the time. If the box is not checked but there is a formula present (the text on the button to the right will be red rather than blue), the object will be suppressed only for records which meet the criteria specified in the formula. In your example, the text box will be suppressed for records where No Valid Address is false (i.e. not ticked) and visible for records where No Valid Address is not false.

Michele Thompson 2

Alan French:

If the Suppress box is checked, the object will be suppressed all the time. If the box is not checked but there is a formula present (the text on the button to the right will be red rather than blue), the object will be suppressed only for records which meet the criteria specified in the formula. In your example, the text box will be suppressed for records where No Valid Address is false (i.e. not ticked) and visible for records where No Valid Address is not false.

Thank you - that makes sense.