Change Case
After Update

Access Expert 25 covers String Functions - including UCase().

Kevin pointed you in the right direction. Put this in the After Update event for that textbox:

UserID = UCase(UserID)

That will convert whatever they entered to uppercase as soon as they leave the field. So aa123, Ae123, or aA123 will all become AA123 or AE123.

If you also want to make sure the ID starts with only AA or AE, that is a separate validation step.

Hi Richard,
I did something similar to that:

Private Sub ID_MMUID_AfterUpdate()

    Me.[ID-MMUID] = UCase([ID-MMUID])

Is that correct or should I do it the way you had it?

Also, my field does not turn grey and lock as soon as I type in an AE employee number.
Here's my code:

Private Sub UpdateContractDateLock()

    ' If the emplyoee has an AE Account then the Contract Date Field
    '   will be greyed out and will be locked.
    
    If Nz(Me.AAorAE.Value, "") = "AE" Then
        'AE Employees will never need a Contract Date
        'Me.ContractDate.Value = Null
        Me.ContractDate.Locked = True
        Me.ContractDate.BackColor = RGB(191, 191, 191)
                      
    Else
        ' AA Employees will have a Contract Date and may have a Hire Date
        Me.ContractDate.Locked = False
        Me.ContractDate.BackColor = RGB(255, 255, 255)
                
    End If
    
                    
    
End Sub

I want it to turn grey and lock as soon as the AE number is typed in.
Also, I would like it to revert back to white and unlock if the AE number is deleted and / or deleted and an AA number is typed instead.

I have to take out the Nz, because if the field is left blank, I don't want anything to happen.

Oops this is the wrong thread.
I'll start a new thread.