I've set up a data grid (ADO) that populates itself from codes. The coding is below


Set ConClientele = New Connection
' This procedure establishes the connection
With ConClientele
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\IDSS\client3.mdb"
.CursorLocation = adUseClient
.Open
End With

Set Rsclientele = New Recordset
'establish the recordset
With Rsclientele
.LockType = adLockOptimistic
.CursorType = adOpenStatic
.Open "SELECT Name, CustAccountNum as [Customer Account No], Contact, Phone, Fax, Address1 as [Address Line 1], Address2 as [Address Line 2], Country, Postcode FROM Clientele ", ConClientele
.Sort = "name asc"
End With

' sets the source for the datagrid
Set grdDataGrid.DataSource = Rsclientele

What would be the best way for me to set up formatting for say the 7th column to only accept numbers or for say the first column to convert to uppercase when i type