Text Box Help/ideas

[Steve Stad]

I have a text box where I insert text based on a button control using the
code below. Is it possible to insert data in a table format in the
helpwindow text box. Also, am I limited to 255 charachters and is it
possible to wrap the test in the VBA code line HelpWindow.Text =
"this.........." with a space and underscore like in a message box.

Private Sub Help1_Click()
HelpWindow.SetFocus
HelpWindow.Text = "this is the text that will appear in the HelpWindow when
the help1 button is clicked"
End Sub

 

[Larry Linson]

I have a text box where I insert text based on a button control using the
code below. Is it possible to insert data in a table format in the
helpwindow text box. Also, am I limited to 255 charachters and is it
possible to wrap the test in the VBA code line HelpWindow.Text =
"this.........." with a space and underscore like in a message box.

Private Sub Help1_Click()
HelpWindow.SetFocus
HelpWindow.Text = "this is the text that will appear in the HelpWindow
when
the help1 button is clicked"
End Sub

1. A text box is not limited to 255 characters. A text field in a table is
limited to 255 characters. Is your text box bound to a text field in a
table?
2. I don't understand what you mean by "insert data in a table format".
3. Try leaving off the ".Text" or using ".Value". Check Help on the
difference between ".Text" and ".Value".
4. Also specify the shortcut "Me." to indicate where the control is located
("this form").
4. This will work to wrap text in the code line (and in my test, display it
in a control on the same form, named "HelpWindow"):
Me.HelpWindow = "This is the code that will appear in the Help
Window" & _
"when the help1 button is clicked"
This, however, will not even compile properly:
HelpWindow = "This is the code that will appear in the Help Window &
_
when the help1 button is clicked"

Larry Linson
Microsoft Office Access MVP

 

[Steve Stad]

Larry, thanks for your reply and sorry for delayed response back.
The text box is not bound to a control, i.e., it is an Unbound text box
where the text/msg changes based on the click() event of several help buttons
on the same form. I have a list of 4 email addresses and phone numbers I
wanted to insert in the same text box in a list or table type format when
clicking a button. I currently open a query to display another table but
wanted to try to insert the list in the same text box as the others.