recordset Update in class to update all records in lower case

[Oliver2003]

Is it possible to update all fields in a record set in lower case (lcase).

I am using a class to get the recordset and the update event is as follows:

Public Sub Update()
With adoPrimaryRS
.UpdateBatch adAffectAll
If .EditMode = adEditAdd Then
MoveLast
End If
End With
End Sub



in the form load event i have:

Private Sub Form_Load()
Set PrimaryCLS = New clsSecurity

Dim oText As TextBox
'Bind the text boxes to the data provider
For Each oText In Me.txtFields
oText.DataMember = "Primary"
Set oText.DataSource = PrimaryCLS
Next
End Sub

Thanks in advance