Write Values from table horizontally

[Brad]

Thanks for taking the time to read my question.

I posted my question under "Create a list that is a string", but am unable
to reply to it. Not sure why. I am logged in.

My probelm is I have e-mail address that I need in the following format.
(e-mail address removed); (e-mail address removed); (e-mail address removed) etc.
It needs to be a string so that the user can copy all the e-mail addresses
and paste them into the To: line on their e-mail editor.

I'm not sure how to do this.

I am using Access97 and Access2000 is not available to me. The reply to my
post "Create a list that is a string" was for Access2000.

Thanks again,

Brad

 

[John Vinson]

I am using Access97 and Access2000 is not available to me. The reply to my
post "Create a list that is a string" was for Access2000.

The same code works fine in 97.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Brad]

I've downloaded it, but it won't open in 97. I'm assuming it's a 2000 db.

Brad

 

[Brad]

Hi John,

Doesn't this just build a line of text in a string variable? Isn't a string
variable limited to 255 characters? What do you do when you need more space
than 255 characters?

Brad

 

[John Vinson]

Hi John,

Doesn't this just build a line of text in a string variable? Isn't a string
variable limited to 255 characters? What do you do when you need more space
than 255 characters?

A text Table field is limited to 255 characters, but a VBA variable
isn't.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Brad]

Great!!!

Thanks so much John,

Have a great day,

Brad