Brad Marks
BradM at blackforestltd.com
Thu May 3 17:11:48 CDT 2012
Steve, Thanks for the idea. I just finish writing the data to a flat file and then using NotePad2 to view the flat file. It turns out that the two bytes are CRLF. There are probably easier ways to do this. Brad PS. Notepad2 is a freebie - I don't use it a lot, but it does come in handy once in a while. PSS. Speaking of freebies - "Fences" is free and it is great! - even my kids like it. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Goodhall Sent: Thursday, May 03, 2012 5:08 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.