This is how you call a SQL Scalar Function in VBA, using ADODB connection to SQL Server.

Dim rst As ADODB.Recordset
Set rst = Connection.Execute("SELECT dbo.MyFunction('" & Me.field & "')")