I'm able to use the function (actually called a method) StringFromGuid to convert replicationIDs to strings using the design view of an Access 2013 query.
The field in design view is
The new stringversion field has entries like
3} which are actually strings. Works fine.
But when I try to use the method GUIDfromString to convert back, I get Chinese characters.
The field in design view to go back to ReplicationID is
When I use a make table query, the new field is a string, not a ReplicationID
I guess the string that is the input to GUIDfromString needs special formatting.
Anyone know how to get this to run in the design window?