[AccessD] Zero-width characters in query

[Charlotte Foust]

I was assured that the values were typed in, but I don't know of any way to
type a tab into a text box when tab is the default action for moving to the
next control.

Charlotte Foust
(916) 206-4336

On Thu, May 25, 2017 at 1:26 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Someone must have imported a badly structured text file into the database
> :(
>
>
> On 25 May 2017 at 8:20, Charlotte Foust wrote:
>
> > I tried that, but the first character wasn't null, it was a chr(9).  I
> > replaced it with a null string to cure the craziness.
> >
> > Charlotte Foust
> > 916-206-4336
> >
> > On May 25, 2017 7:56 AM, "Rocky Smolin" <rockysmolin at bchacc.com>
> > wrote:
> >
> > > Not a solution but if you retrieved the second character in the
> > > string in the event that the fist character was blank or null, would
> > > that second character actually be the first character in the string?
> > >  Or be the second character?
> > >
> > > Rocky
> > >
> > >
> > > -----Original Message-----
> > > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On
> > > Behalf Of Charlotte Foust Sent: Wednesday, May 24, 2017 10:49 PM To:
> > > Access Developers discussion and problem Subject: [AccessD]
> > > Zero-width characters in query
> > >
> > > I ran into something today that left me scratching my head.  I ran a
> > > query to extract the first letter of a company name to use as an
> > > index.  About 42 out of some 60k came back empty and no editing I
> > > could do would change that.
> > >
> > > I hunted around the internet and found a few issues with SharePoint
> > > and Unicode but nothing that made sense in context.  Have any of you
> > > ever happened on this?  I found a way to fix the fields, because i
> > > could find no way to query around it.  The length of the string was
> > > for the visible characters, but the first character wasn't visible.
> > >
> > > Charlotte Foust
> > > 916-206-4336
> > > --
> > > 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>