Doug Murphy
dw-murphy at cox.net
Thu May 3 17:12:17 CDT 2012
Could you run the Asc function on each character in the field and see what they are? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Thursday, May 03, 2012 2:44 PM To: Access Developers discussion and problem solving Subject: [AccessD] How to see what a field contains with Access 2007 All, We have an Access 2007 application that reads data from a Firebird database via ODBC. There is a field that appears to be spaces but it is not spaces. We did a "trim" and it went from 10 bytes to 2. We have tested for spaces and it appears that the two bytes are something other than spaces. We would like to see what is in these two bytes. In a prior life (IBM Mainframe) we had utilities to "view in Hex". Is there anything like this for Access? Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com