Link to home
Start Free TrialLog in
Avatar of choccarlm
choccarlm

asked on

Printing to a hidden form

Hi, I currently have 3 forms. A login form, a main menu, and a form that links off from the main menu. When you login, the login form unloads and then displays the main menu. This is the same for the third form. In the third form, I have three text box's, and a submit button. When the submit button is hit, I would like it to print the three variables to some sort of text box, but to keep that text box hidded. I then want it to give the user the option (some sort os msgbox) of returning to the third form to append futher info to the hidden textbox. If the user chooses not to, i would then want the third form to hide all field and labels, and to display the hidden text box. Thanks.
Avatar of CJ_S
CJ_S
Flag of Netherlands image

how far are you yourself with this?

for each c in controls
   c.visible = false
next
hiddentextboxname.visible = true
Avatar of choccarlm
choccarlm

ASKER

Thanks, that hides and displays what I want perfectly. But I still need it to pass on information onto the hidded textbox from the three fields. How do I do That?

I will need it to write to the hidden box first. Then propmt them if they would like to append to this. If yes, then the textbox will remain hidden, until they no longer wish to append to it.
writing to the box is done through

hiddentextboxname.text = "newtext"

What kind of fields are the 3 fields? Plain textfields?

hiddentextboxname.text = text1.text & text2.text & text3.text




all 3 field will be on seperate lines. They are all plain text, and will all have set text before them.
all 3 field will be on seperate lines. They are all plain text, and will all have set text before them.
hiddentextboxname.text = text1.text & vbcrlf & text2.text & vbcrlf & text3.text

??

can you be more clear in what you want?
I want it to append data to a hidden textbox, until the user wishes to stop appending. In this instance, it will display all data that has been entered into the hidden file. Once the "submit" button has been hit, it will first append to the hidden form. It will then ask the user (msgbox,..,vbYesNo,) if they would like to enter any more data (Using the 3 fields). If the answer is yes, it will display the form, and append to the first set of data. It will then prompt the user again and again, until they choose "no". Once they choose no, it will unhide the text box, and display all text within it.

Hope this makes sense. I'm knew to VB and as you can see, im having trouble.
hiddentextboxname.text = hiddentextboxname.text & vbCrLf & text1.text & vbcrlf & text2.text & vbcrlf & text3.text

that will append it
I know how to get it to propmt if they wish to append, but how do I know if they hit "yes" or "no" in the msgbox?
I have used (msgbox "....", vbYesNo, "......", ). This displays the message box, with the question and 2 buttons (Yes / No), but im not sure how to read the users answers.
Any ideas?

I will award the points on this one.
If (MsgBox("Check", vbYesNo) = vbOK) Then
   
Else
   
end if

Regards,
CJ
ASKER CERTIFIED SOLUTION
Avatar of CJ_S
CJ_S
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks a lot. That was really helpful. One more small question. How do you select all text within a textbox, and copy it to the clipboard?

Thanks
I'm sorry, but that hasn't been mentioned in the question you wrote above. If you would';ve given me an A I probably would';ve given you the code...but not for a B. I'm sorry...
No Probs.