By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,061 Members | 1,523 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,061 IT Pros & Developers. It's quick & easy.

Creating a new line in a calculated text box

P: n/a
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

Aug 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Aug 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.