StringFromGUID Method

Microsoft Access Visual Basic

Show All

StringFromGUID Method

       

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

expression.StringFromGUID(Guid)

expression   Required. An expression that returns one of the objects in the Applies To list.

Guid  Required Variant. An array of Byte data used to uniquely identify an application, component, or item of data to the operating system.

Remarks

The Microsoft Jet 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 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.

Note that in order to bind a control to the s_GUID field of a replicated table, you must click Options on the Tools menu and select the System Objects check box on the View tab of the Options dialog box.