Application.GUIDFromString Method

  • Article
Access Developer Reference

The GUIDFromString function converts a string to a GUID, which is an array of type Byte.

Syntax

expression.GUIDFromString(String)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
String Required Variant A string expression which evaluates to a GUID in string form.

Return Value
Variant

Remarks

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.

Example

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.

Visual Basic for Applications 
  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(<strong class="bterm">GuidFromString(</strong>rst!s_GUID<strong class="bterm">)</strong>)

Set rstEmployees = Nothing
Set dbsConn = Nothing



End Sub

See Also