Print multiple data fields (pre-formated) into a text box

[auchia]

I am trying to make a database application. Users will input data into a number of fields(saved to an access database) and then click a button to populate a text box with all the data entered in a predetermined format. I.E.:

User types in name, street address, city, state, and zip into five different boxes.
They could then hit a button and a sixth box would take the data and display it like

name
street address
city, state zip

It would format it on multiple lines and add commas or other characters in between the sets of data.

Any hints or directions to information on doing this would be appreciated.

Chris
(I am using VB 2005)

[albertw]

I am trying to make a database application. Users will input data into a number of fields(saved to an access database) and then click a button to populate a text box with all the data entered in a predetermined format. I.E.:

User types in name, street address, city, state, and zip into five different boxes.
They could then hit a button and a sixth box would take the data and display it like

name
street address
city, state zip

It would format it on multiple lines and add commas or other characters in between the sets of data.

Any hints or directions to information on doing this would be appreciated.

Chris
(I am using VB 2005)

hi
make your new textbox 'multiline' and use something like:
text1.text = Name & vbCrLf & Street & vbCrLf & City & ", " & State & " " & Zip

[Killer42]

hi
make your new textbox 'multiline' and use something like:
text1.text = Name & vbCrLf & Street & vbCrLf & City & ", " & State & " " & Zip

You might also consider using the vbNewline constant rather than vbCrLf. Same value, I believe, but a more "readable" name.