If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
single text box to multi text box
Hello, I need to have a text box that show a single line when is view in the
form then if I click on it or move the mouse over it will show multiple lines with it's data, sample: client: john doe "single line" now I go and over the field or click the field and I see client:john doe jane doe ect. ect. and when I move the mouse away or click the next field goes bank to: client: john doe "single line" can this be done with out select box is not a selection the data would be enter like this jonh doe, jane doe, ect.,ect. Help and thanks Rafael |
#2
|
|||
|
|||
single text box to multi text box
You can use a MouseMove Event to display the contents of the textbox in a
ControlTip like: Private Sub txtWhatever_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) If Not IsNull(txtWhatever) Then txtWhatever.ControlTipText = txtWhatever End If End Sub or use it to grow the textbox: Private Sub txtWhatever_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.txtWhatever.Height = 1440 ' twips which is 1 inch End Sub but you'll also need to put it back in the form's detail section: Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.txtWhatever.Height = 280 ' twips End Sub You might also use the text box's Got and Lost focus events to do the same. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "rafaeljsg" wrote in message ... Hello, I need to have a text box that show a single line when is view in the form then if I click on it or move the mouse over it will show multiple lines with it's data, sample: client: john doe "single line" now I go and over the field or click the field and I see client:john doe jane doe ect. ect. and when I move the mouse away or click the next field goes bank to: client: john doe "single line" can this be done with out select box is not a selection the data would be enter like this jonh doe, jane doe, ect.,ect. Help and thanks Rafael |
Thread Tools | |
Display Modes | |
|
|