Hi guys,
Lets say i need to display a few fields onto a text box and i have about 50 of them. How do i code the page up/down button.
E.g
Name Tel Address
jax 5454545 JHashdkjsdhkjsdhfkj
lax 5465444 dfgksdiogpdiogpoigpo
PageDown PageUp
Printable View
Hi guys,
Lets say i need to display a few fields onto a text box and i have about 50 of them. How do i code the page up/down button.
E.g
Name Tel Address
jax 5454545 JHashdkjsdhkjsdhfkj
lax 5465444 dfgksdiogpdiogpoigpo
PageDown PageUp
Not sure what the question is?
PageUp/Down Button.
What exactly are you after?
Perhaps he means this:
Code:
-------------------------------------
Dim i As Integer
'With Text1.Multiline = True preset
With rs
.MoveFirst
For i = 0 To 49 ' "50 of them"
Text1.Text = Text1.Text & .Fields(¡°Name¡±) & .Fields(¡°Tel¡±) & .Fields(¡°Address¡±) & Chr$(10) & Chr$(13)
.MoveNext
If .Eof Then Exit For
Next i
End With
-------------------------------------
IHailJoe
[Edited by xmin on 10-28-2000 at 11:35 AM]
Thanks but my questions are still not answered.
If i only want to display 10 of them at a time out of the total number(this number is not hardcoded)
How would i proceed abt making the page up and down buttons now?
You don't have to code the page up and down buttons. Just set Text1.Multiline = True (and the Scrollbar property) in designing and you can use the buttons.
Or you mean to code the buttons so that the text in the textbox scrolls automatically? If so I can not answer that.