use vba to press enter key 1

[autex]

I have a form that displays personal info. User presses a button that brings up a pop up form that shows certain info: name, address etc. so that the user may copy and paste this information in a usable form somewhere else. Right now I'm using an unbound form with a big textbox in it. Unless you can suggest a better way to do this, what code do I use to get the cursor to start a new line in the textbox?

Get this:
My Name
My address
My city, st, zip

instead of this:
My name My address my city, st, zip

 

[PWise]

i dont know how you get the info in to the unbound txbox but change in to my name & vbcrlf & myaddress & vbcrlf & ....

 

[autex]

oh I got ya thanks, that's not my variables just how I want the display to work. I've been playing with this and this is the best I got. Please let me know if I'm being silly

Me.Text0.SetFocus
SendKeys name & "{enter}" & company & "{enter}" & company1 & "{enter}" & company2 & "{enter}" & city & "{enter}" & state & "{enter}" & zip

 

[PHV]

What about this ?
Me.Text0.SetFocus
Me.Text0 = name & vbCrLf & company & vbCrLf & company1 & vbCrLf & company2 & vbCrLf & city & vbCrLf & state & vbCrLf & zip

You may have to play with vbLf or vbCr instead of vbCrLf.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PWise]

with pvh's method you dont need Me.Text0.SetFocus

 

[autex]

Oh sorry pwise I didn't realize you were introducing vbcrlf I hadn't seen that before. Thanks both of you. I'll play with this.

 

[Tigerlili3]

You can also use the ascii code for the carriage return in your text box:

Me.Text0 = name & Chr(13) & company & chr(13) & company1 & Chr(13) & company2 & Chr(13) & city & Chr(13) & state & Chr(13) & zip