Re: Populate textbox with multiselect list box
- From: "Manuel C via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
- Date: Tue, 09 Aug 2005 12:21:40 GMT
Thanks for your reply Arvin
I had also tried with Chr(13) Chr(10) and still got the same result. What i
ended up doing was adding a space (& " ") after vbNewLine. For some reason
the unprintable character is not visible if it is not the last character
typed. What i get now is a space before the name of each report. It is
probably not the best fix, but a small space is more aesthetically pleasing
that the unprintable character box.
Thanks again Arvin for your suggestions
Arvin Meyer [MVP] wrote:
>There is no equivalent for vbNewLine in Windows/Ascii characters, so Access
>can't print it and you see the square for each unprintable character. You
>might try adding a Carriage Return and Line Feed with: Chr(13) & Chr(10) so
>you might try:
>
>strList = strList & .Column(0, varItem) & Chr(13) & Chr(10)
>
>The comma is required as a data separator
>> Thank you for your reply. Your code works perfectly as it is!
>>
>[quoted text clipped - 36 lines]
>> >>
>> >> Thanks for your help
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200508/1
.
- References:
- Populate textbox with multiselect list box
- From: Manuel C via AccessMonster.com
- Re: Populate textbox with multiselect list box
- From: Arvin Meyer [MVP]
- Re: Populate textbox with multiselect list box
- From: Manuel C via AccessMonster.com
- Re: Populate textbox with multiselect list box
- From: Arvin Meyer [MVP]
- Populate textbox with multiselect list box
- Prev by Date: RE: How do I check if a hidden form is open/loaded?
- Next by Date: Re: Form does no longer bind to table
- Previous by thread: Re: Populate textbox with multiselect list box
- Next by thread: How to stop code in procedure when opening new form
- Index(es):