Write Values from table horizontally

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

Guest

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
 
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
 
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?
Click to expand...

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
 
Back
Top