Thanks Richard, I did that but it doesn't get rid of the entire field, I still have an empty line in the middle of an address. Access is able to do it on its Labels Wizard, ie move lines up so that there are no empty gaps, but I don't know how to do it on my generic letter.
Also, you had mentioned about being able to leave the 'Country' field blank if the country was the U.S. You said you covered it in a previous class but I've not come across it and it would be useful to be able to do. Could you let me know the critera for leaving a particular country blank in a query? Thanks
Reply from Richard Rost:
I would have to see your report to tell you exactly what the problem is, but that's all you SHOULD have to do.
As far as leaving a country blank... just don't type anything into the field. There isn't any special trick. Then, if it's on a line by itself in your report, and its CanShrink property is set to yes, it should effectively disappear.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 204.