Creating a new line in a calculated text box

[administrator]

Hi,

I'm having trouble with a calculated text box.

"=[Outcome 1] & [Outcome 2] & [Outcome 3] & [Outcome 4] & [Outcome 5] &
[Outcome 6] & [Outcome 7] & [Outcome 8] & [Outcome 9] & [Outcome 10] &
[Outcome 11] & [Outcome 12] & [Outcome 13] & [Outcome 14] & [Outcome
15]"

This produces the correct results, but I want it to create each outcome
below the previous one, and to be honest I'm stumped.

Oliver
A very occasional access user lol

[fredg]

On 3 Aug 2006 07:36:47 -0700, ad***********@m1motorparts.co.uk wrote:

Hi,

I'm having trouble with a calculated text box.

"=[Outcome 1] & [Outcome 2] & [Outcome 3] & [Outcome 4] & [Outcome 5] &
[Outcome 6] & [Outcome 7] & [Outcome 8] & [Outcome 9] & [Outcome 10] &
[Outcome 11] & [Outcome 12] & [Outcome 13] & [Outcome 14] & [Outcome
15]"

This produces the correct results, but I want it to create each outcome
below the previous one, and to be honest I'm stumped.

Oliver
A very occasional access user lol

In a report?
=[Outcome 1] & chr(13) & chr(10) & [Outcome 2] & chr(13) & chr(10) &
[Outcome 3] & etc.

Remember to set the control's CanGrow property to Yes.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail