Application.GUIDFromString Method (Access)
The GUIDFromString function converts a string to a GUID, which is an array of type Byte.
The Microsoft Access database engine stores GUIDs as arrays of type Byte. However, Microsoft Access can't return Byte data from a control on a form or report. In order to return the value of a GUID from a control, you must convert it to a string. To convert a GUID to a string, use the StringFromGUID function. To convert a string to a GUID, use the GUIDFromString function.
The following example uses the GUIDFromString function to convert a string to a GUID. The string is a GUID stored in string form in a replicated Employees table. The field, s_GUID, is a hidden field added to every replicated table in a replicated database.
Sub CheckGUIDType() Dim dbsConn As ADODB.Connection Dim rstEmployees As ADODB.Recordset ' Make a connection to the current database. Set dbsConn = Application.CurrentProject.Connection Set rstEmployees = New ADODB.Recordset rstEmployees.Open "Employees", dbsConn, , , adCmdTable ' Print the GUID to the immediate window. Debug.Print rst!s_GUID Debug.Print TypeName(rst!s_GUID) Debug.Print TypeName(GuidFromString(rst!s_GUID)) Set rstEmployees = Nothing Set dbsConn = Nothing End Sub