>I am stuck on the smallest, yet most annoying, detail of the database which I have created. Having created a database which generates invoices from a list of clients, I have come to the last part which is to create a report which prints the invoice.
>
>When setting up the part of the invoice report which has the clients address, I need to concatenate the fields 'Town', 'County' and 'postcode' together in one unbound text box, but I only know how to put a space in between the fields by using : & " " & [Postcode] & " " &, etc. What I want is to put a new line in between each new field so it looks like a proper address. I know there must be an operator that allows you to do this, but I just can't find it! It seems like such a simple thing, but I am completely stuck.
>
>The other thing I can't work out is if it is possible to use an append query to append data to a linked table which is in excel. When I try, access tells me that the spreadsheet I am trying to append to is full, which is impossible.
>
>Any help would be greatly appreciated as my deadline is coming close and I am amazingly frustated as it is such a simple thing!
>
>thank you!
>lisa williams.

Lisa,

To add a new line character you can concatenate the vbCRLF constant or use Chr(13) & Chr(10). Although I'm not positive this will have the desired effect on the Access report. Try it and let us know how that goes.

Don't know about the Excel message.