Hi there, I've used animated gifs on my forms without using any activeX controls. All you need is the timer event and some VBA coding know how.
First you'll need to split the animated gif up into it's separate pictures and store each picture as a separate gif file. There are some utilities out there which can do this.
Next put all of the separate gifs on your form. Each in the exact same position on the form and set the visible property to false for all the images except the 1st one.
Now you need to set your Timer interval (200 works good) and put code in the timer event to switch the visibility of each image.
Here's an example for an animated gif composed of 3 images.
Private Sub Form_Load()
Me.TimerInterval = 200
Me!image1.Visible = True
Me!image2.Visible = False
Me!image3.Visible = False
End Sub
Private Sub Form_Timer()
If Me!image1.Visible = True Then
Me!image1.Visible = False
Me!image2.Visible = True
ElseIf Me!image2.Visible = True Then
Me!image2.Visible = False
Me!image3.Visible = True
Else
Me!image3.Visible = False
Me!image1.Visible = True
End If
End Sub
Maq
![[americanflag] [americanflag] [americanflag]](/data/assets/smilies/americanflag.gif)
<insert witty signature here>