Computer Programming is interesting because when you start doing something it will definitely lead to more than that and give you more ideas to try different things all the time. I have started with the Label Animation methods and thought of presenting one or two tricks but we have gone through five different animation methods by now.

We are going to learn one more trick with the same Form and Labels, which we have used last week. All you need to do is to copy the new VBA Code given below into the Code Module of the Form.

A sample image of the Run of the Program is given below:


In this method the Color of each letter of the Employee name is slowly fading away to distance. The size of each letter of the name is getting reduced at each step and the letters are displayed at a fixed time of interval giving it an animated and three dimensional effect.

If you have not tried out the earlier Label animation methods you may take a look at them by visiting the following pages:

Label Animation Style-1

Label Animation Style-2

Label Animation Variant

Label Animation Zoom-in Style

Label Animation in Colors

Let us try the new method.

  1. Make a copy of the Employees Form we have used last week with twenty small labels with the Name Property set the with the Values lbl01 to lbl20.

    Sample image of the Form is given below for reference:


  2. Open the Employees Form you have copied in Design View.
  3. Display the Code Module of the Form (View – -> Code).
  4. Copy and paste the following VBA Code into the Module, over-writing the existing Code:
    Option Compare Database
    Option Explicit
    Dim j, txtName, ctrl As Label, i
    Private Sub Form_Current()
    Dim t, xRGB As Long, fsize
    txtName = UCase(Me![first name] & " " & Me![Last name])
    fsize = 22
    For j = 1 To 20
       Set ctrl = Me("lbl" & Format(j, "00"))
       ctrl.FontSize = fsize
       ctrl.Caption = ""
       fsize = fsize - 1
    xRGB = RGB(10, 10, 10)
    i = xRGB
    For j = 1 To Len(txtName)
       Set ctrl = Me("lbl" & Format(j, "00"))
       xRGB = xRGB + i
       ctrl.ForeColor = xRGB
       ctrl.Caption = Mid(txtName, j, 1)
    t = Timer
    Do While Timer < t + 0.1
    End Sub
  5. Save the Form with the Code and open it in normal view.
  6. Use the Record Navigation Button and move the record forward or back and watch how the Employee name is displayed on the header of the form.