Michelle,
You should be able to put this expression in your select:
name + chr(13) + chr(10) + address + chr(13) + chr(10) + ...
In the report designer make sure the field is check to overflow to a new line if needed.
>I would like to store a name and full address in a single field, since it is only there for display purposes and I have no need to access the individual components.
>
>The table that it is coming from, however, has all the pieces in seperate fields.
>
>I want to be able to do: Name+address+city...
>
>The problem is that if I do this, when I put the string into a report, there's no way (that I know of) to tell it to put the name on one line, then address on another, etc.
>
>Is it possible to insert carraige returns into the string that the report designer will recognize? So I'd have: Name+"
"+address...
