How do I set up a marquee in an access form / report?

[Guest]

I am trying to add a scrolling text in a form / report. I know that can be
done in data access page but there should be way to do that in form also. Can
anyone help me?

 

[fredg]

You would use code in the form's timer event.

Add a label to the form.
Set the Timer Interval to 1000.

Code the Timer event:

Private Sub Form_Timer()
Dim strMsg As String
Static I As Integer
I = I + 1
strMsg = "some message here "
' Display then exit
If I > Len(strMsg) Then Exit Sub
' or if you wish to repeat the message
' If I > len(strMsg) Then I = 1
Label0.Caption = LabelName.Caption & Mid(strMsg, I, 1)

End Sub