GUID field does not retrieve data properly - Access 2003 BUG?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I attempt to get the value of a field bound to a GUID SQL field, the
value is returned as eight question marks - "????????" rather than the actual
GUID value. I can put a visible field on the form that is bound to the GUID
field, and it will display the value properly. I simply cannot access the
value programmatically. Is there anyone out there with some insights into
what is going on here or is this just a (showstopping) Access 2003 bug?
 
Finally got the problem solved. If anyone else is experiencing this, here's
help. You cannot use the StringFromGUID function on the actual data. For
example, if the field is in table ExampleTable and the fieldname is
GUIDField, you cannot use StringFromGUID(me.GUIDField) directly. You can
only refer to a control that is bound to that data.

The solution requires that place a field on the form, bind it to GUIDField,
and then name it something like txtGUIDField. (The name is unimportant.)
Then, you can refer to the StringFromGUID(me.txtGUIDField) and get the full
string representation.

Hope this helps someone else!
Jeff
 
Back
Top