Rocky Smolin
rockysmolin at bchacc.com
Thu May 3 21:46:18 CDT 2012
Second that on Fences - I use it and it's wonderful. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Thursday, May 03, 2012 5:25 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to see what a field contains with Access 2007 Yes, Fences is great - I also used Stardock's "Tiles" at work, which is real handy for grouping 'stuff' together etc. Tiles is not free, but it has been worth the $9 US or so I paid. I am not sure I would like it some much on a small, or even single monitor, but I have two great big monitors at work with gobs of spare screen space. Cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, 4 May 2012 8:12 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to see what a field contains with Access 2007 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. -- 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