List On Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

I want to make a list on my form, but don't want to make a lot of text boxes
as I don't know how many will be needed.

So I was thinking I could put all my info into one text box, except I can't
make it look like a list.

Example:

Wanted:
____________________
| |
| Line One |
| Line Two |
| Line Three |
| Line Four |
----------------------------
Getting:
____________________
| Line One Line Two Line |
| Three Line Four |
| |
------------------------------

I'm putting all my data into a text box. I tried using Chr(13) to force a
return, but all I get is a box in my text instead of the return

Is it possible to do this?

I know I could add a bunch of empty text boxes, hide them, then as I need
them fill them and make them visible... would like to avoid that. I would
make them as needed but you can only do that in the design view of the form,
and I can't go from using the form to editing it, and then continue using the
form.

I digress. : )

Thanks for your help.

Brad
 
I came up with a solution.

use a ListBox, change the RowSourceType to Value List, and when building the
String to set as the ListBox RowSource, separate each value with a semi colon.

It works perfectly.

Brad
 
Back
Top