I got a table that has the seperate lines of an address for a customer 
stored in individual fields, These are displayed on a form in seperate 
text boxes.  I could do with these being saved from the form into a 
teporary table (already created) so that it can be displayed in a single 
text box on a report with each line one underneath the other.  Any 
suggestion gratly appreciated.

Thanks

Hello Andrew

You dont necessariy need to use a temporary table (unless there's some other
reason)  you can take the textbox values straight from the form if you
wish.. If you then set the height property of the corresponding textboxes on
your report to '0' and the 'can grow' property to 'Yes' then group them
quite close together, they will only display if they have a value - this may
be useful in the case of addresses with some blank lines, since these will
not display.  Hope this helps.

Wesley Kendrick


----- Original Message -----
From: "Andrew Payne" <andrew@p...>
To: "Access" <access@p...>
Sent: Thursday, March 13, 2003 4:05 PM
Subject: [access] Address's (the sort you put on a letter)


> I got a table that has the seperate lines of an address for a customer
> stored in individual fields, These are displayed on a form in seperate
> text boxes.  I could do with these being saved from the form into a
> teporary table (already created) so that it can be displayed in a single
> text box on a report with each line one underneath the other.  Any
> suggestion gratly appreciated.
>
> Thanks