[AccessD] How to see what a field contains with Access 2007

I would write code to walk through it character by character and display the
ASCII equivalent.  Bear in mind that this is untested "air code."

For i = 1 to len(sValue)
	debug.print asc(mid(svalue,i,1))
next

Regards,

Steve Goodhall, MSCS, PMP



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, May 03, 2012 5: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