multiple results in one textbox

[enrico via AccessMonster.com]

i saw a sample in the net where the results in a query are shown in only one
textbox. for example, states in US. like you query states in the northwest
part. it will definitely return more than one result. when i open the form in
design view it uses a textbox and there's only one. how do you make one?

 

[Mike Painter]

i saw a sample in the net where the results in a query are shown in
only one textbox. for example, states in US. like you query states in
the northwest part. it will definitely return more than one result.
when i open the form in design view it uses a textbox and there's
only one. how do you make one?

You would have to write code to loop through the query and create a string
of the states.
If it *has* to be in the form "Alabama, California, Florida,... " that's
about the only way.

Far easier woud be to return the query in a subform or listbox.