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

Me three on Fences, although I use the Pro version.

Charlotte

On Thu, May 3, 2012 at 7:46 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> 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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>