Code for ControlTip Text

[Gepetto]

I need to ControlTip Text show records from List box with 3 rows. When i try
with Me!CmdBtn.ControlTip Text = List1.text, Controltip Text show only record
in first row, but i need to show all those records.

Thanks a lot,
Gepetto

 

[Damon Heron]

If you always have only three entries in the listbox, then you could use
this:
Me.CmdBtn.ControlTipText = List1.ItemData(0) & " " & List1.ItemData(1) & "
" & List1.ItemData(2)

Damon

 

[rigor via AccessMonster.com]

Yes, but i have two or three records in each row,
Gepetto

If you always have only three entries in the listbox, then you could use
this:
Me.CmdBtn.ControlTipText = List1.ItemData(0) & " " & List1.ItemData(1) & "
" & List1.ItemData(2)

Damon

I need to ControlTip Text show records from List box with 3 rows. When i
try

[quoted text clipped - 4 lines]

Thanks a lot,
Gepetto

 

[Damon Heron]

We need to agree on definitions. By saying you have 2-3 "records" in each
row, I am left a bit bewildered. Do you mean you have 2-3 columns in each
row of the listbox?
You may have to design your string something like this:
Me.CmdBtn.ControlTipText = list1.column(0,0) & " " & List1.Column(0,1) & " "
& list1.column(0,2) & " " & .....
where the numbers are (column, row).

Damon

Yes, but i have two or three records in each row,
Gepetto

If you always have only three entries in the listbox, then you could use
this:
Me.CmdBtn.ControlTipText = List1.ItemData(0) & " " & List1.ItemData(1) &
"
" & List1.ItemData(2)

Damon

I need to ControlTip Text show records from List box with 3 rows. When i
try

[quoted text clipped - 4 lines]

Thanks a lot,
Gepetto

 

[rigor via AccessMonster.com]

Yes, i am sorry, my head is like a house now.
This working!

We need to agree on definitions. By saying you have 2-3 "records" in each
row, I am left a bit bewildered. Do you mean you have 2-3 columns in each
row of the listbox?
You may have to design your string something like this:
Me.CmdBtn.ControlTipText = list1.column(0,0) & " " & List1.Column(0,1) & " "
& list1.column(0,2) & " " & .....
where the numbers are (column, row).

Damon

Yes, but i have two or three records in each row,
Gepetto

[quoted text clipped - 12 lines]