Print Anomaly

[bkessinger]

Greetings all:

I have this application that creates and prints customer invoices. The customer name, address, address2, city, state, zip are entered on a form and a command button prints when all the information is entered, as shown on the attachment. If there is no address2 all prints okay; if there is an address2, it prints on the invoice before address. I have interchanged the text boxes on the invoice and if there is no address2, a blank line appears between address and city, state, zip. Explanation is depicted on the attachment. TIA.

Bill Kessinger

[HansV]

The cause of the problem is that the lower of the two address text boxes, whether it is bound to Address1 or Address2, overlaps horizontally with OCA 1, Index and IndexTotal. Since the latter aren't empty, Access can't shift the controls upwards.

A possible workaround is to replace the Address, Address2 and City/State/Zip text boxes with a single text box that is tall enough to accomodate three lines, with Control Source

=[Address] & (Chr(13) & Chr(10))+[Address2] & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

[bkessinger]

Hans:

The workaround worked great. Thanks again.

Bill