Application.StringFromGUID method (Access)

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

Syntax

expression.StringFromGUID (Guid)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
Guid	Required	Variant	An array of Byte data used to uniquely identify an application, component, or item of data to the operating system.

Return value

Variant

Remarks

The Microsoft Access database engine stores GUIDs as arrays of type Byte. However, Access can't return Byte data from a control on a form or report. 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 back to a GUID, use the GUIDFromString function.

For example, you may need to refer to a field that contains a GUID when using database replication. To return the value of a control on a form bound to a field that contains a GUID, use the StringFromGUID function to convert the GUID to a string.

Example

The following example returns the value of the s_GUID control on an Employees form in string form and assigns it to a string variable. The s_GUID control is bound to the s_GUID field, one of the system fields added to each replicated table in a replicated database.

Public Sub StringValueOfGUID() 
 
 Dim ctl As Control 
 Dim strGUID As String 
 
 ' Get the GUID. 
 Set ctl = Forms!Employees!s_GUID 
 Debug.Print TypeName(ctl.Value) 
 
 ' Convert the GUID to a string. 
 strGUID = StringFromGUID(ctl.Value) 
 Debug.Print TypeName(strGUID) 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.