The StringFromGUID function converts a GUID, which is an array of type Byte, to a string.
Syntax
StringFromGUID(guid)
The StringFromGUID function has the following argument.
Argument | Description |
---|---|
guid | 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.