Changeing key behaviour in report

[rick roberts]

i have an Address textbox that has key behaviour as - new line in field. this allows me to put the complete address in one box, post code is another textbox. this is fine if i want to create window envelopes but - if i want the address to look as one long line in a report it wont work
since the address in the form takes up two lines -- only the first line shows in the address column of the table - hence only one row shows in the report that derives from that table SO =[Address]&" "&[PostCode] placed in the Source Code of the address only shows the first line plus post code . if i make the box deeper then it will show - but only as a second line - i want it all to be one line
can i get out of this and still keep the -new line in field- behaviour?
thanks in anticipation

 

[Rabbie]

If you store each line of the address in separate fields you can simply concatenate them with a space between each row to get a single line or with a newline between them to get an address label.

Alternatively you could use Replace to change the newlines in your existing string to spaces where required.

 

[rick roberts]

can you elaborate on the replace method please

 

[Rabbie]

Basically you use it like this

Newstring = Replace(Oldstring,charstobe replaced,newchars)

See Access help for more details of Replace Function