textbox on a form

[Mark]

I am trying to display some text in a textbox. The problem
is the text has become too large to display in one textbox.
I am extracting some figures from a database table, and
putting the results into an array, so I end up with for
example:
arr[0] = "1"
arr[1] = "25"
arr[2] = "35"
arr[3] = "135"
arr[4] = "1135"

I then want to display these results in a textbox on a
form, so it looks like "1, 25, 35, 135, 1135".
This is fine until I reach the maximum number of
characters that a text box allows. I think I should be
using a datalist/listbox or similar??? but I can't
remember how to code this.

 

[Sandra Daigle]

Hi Mark,

Can you explain why you want to do this?

It does sound like a listbox would work better for you. This is simple to
add - just click on the listbox icon in the toolbar, drop it on your form
and then let the wizard lead you through setting up the rowsource.