is this possible?

[Jim Allen]

I'm new to Access reports. I have a query that brings
back several memo fields. I would like to concatinate
them into a single field on a report with additional
formatting for example.
In my table I have memo1, memo2, memo3 etc. each may or
may not have data.

For my example let's assume memo2 is empty, I would like
my report to have a single that displays...
Memo1:
The contents of memo1
Memo3:
The contents of memo 3

Any help would be appreciated.
Thanks.
Jim

 

[Marshall Barton]

I'm new to Access reports. I have a query that brings
back several memo fields. I would like to concatinate
them into a single field on a report with additional
formatting for example.
In my table I have memo1, memo2, memo3 etc. each may or
may not have data.

For my example let's assume memo2 is empty, I would like
my report to have a single that displays...
Memo1:
The contents of memo1
Memo3:
The contents of memo 3

Set the text box's control source expression to:

=("Memo 1: " + [memo1]) & ("Memo 2: " + [memo2]) & . . .

this works because + propogates nulls, but & does not.

 

[Guest]

Thanks Marsh. I was using '&' and couldn't figure out
what was the problem.

-----Original Message-----

I'm new to Access reports. I have a query that brings
back several memo fields. I would like to concatinate
them into a single field on a report with additional
formatting for example.
In my table I have memo1, memo2, memo3 etc. each may or
may not have data.

For my example let's assume memo2 is empty, I would like
my report to have a single that displays...
Memo1:
The contents of memo1
Memo3:
The contents of memo 3

Set the text box's control source expression to:

=("Memo 1: " + [memo1]) & ("Memo 2: " + [memo2]) & . . .

this works because + propogates nulls, but & does not.