[AccessD] Zero-width characters in query

Bill Benson bensonforums at gmail.com
Fri May 26 14:57:38 CDT 2017


When the user has copied and pasted the data from a source in Word or
another program, into a field in Access, I believe tabs go in as CHR(9)
without the user having to physically touch the tab key themselves. But
Maybe I am imagining this memory.

On Fri, May 26, 2017 at 3:16 PM, Charlotte Foust <charlotte.foust at gmail.com>
wrote:

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


More information about the AccessD mailing list