467,151 Members | 949 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

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

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)
Nov 5 '06 #1
  • viewed: 1566
Share:
2 Replies
100+
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
Nov 5 '06 #2
Expert 8TB
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.
Nov 5 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by MouseHart | last post: by
1 post views Thread by Bob T | last post: by
1 post views Thread by cmpirie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.