RE: [MS_AccessPros] Re: leading or trailing spaces/characters??

I think there is a carriage return and line feed in the field.

To: MS_Access_Professionals@yahoogroups.com
From: glcass58@yahoo.com
Date: Thu, 1 Mar 2012 05:08:10 +0000
Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??

How does this type of thing happen? Is this something to worry about?

Thanks again.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:

>

> Earlier, I think you said you got 10 as the length. MC63 MC63 is 9. Most

> puzzling. What is the length of the field in table design, and what is the

> longest ID value you have? If they are all 4 characters, you could change the

> length to 4, and Access will truncate the field.

>

> John Viescas, author

> Microsoft Office Access 2010 Inside Out

> Microsoft Office Access 2007 Inside Out

> Building Microsoft Access Applications

> Microsoft Office Access 2003 Inside Out

> SQL Queries for Mere Mortals

> http://www.viescas.com/

> (Kirkland, WA)

>

>

>

>

> -----Original Message-----

> From: MS_Access_Professionals@yahoogroups.com

> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58

> Sent: Wednesday, February 29, 2012 6:54 PM

> To: MS_Access_Professionals@yahoogroups.com

> Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??

>

> Asc(Left(ID, 1)) returns 77 which I see is M.

> When I copy to the clipboard it shows "MC63 MC63". When I copy a different

> value, it pastes correctly- just one time. Why is MC63 twice?

> Thanks again for your help.

>

> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:

> >

> > Chr(51) is the number 3, which is what you would expect in a field containing

> > "MC63".

> >

> > What does Asc(Left(ID, 1)) return?

> >

> > Also, open the table in Datasheet view, select the row containing MC63, copy

> it

> > to the clipboard, then paste it into a reply.

> >

> > John Viescas, author

> > Microsoft Office Access 2010 Inside Out

> > Microsoft Office Access 2007 Inside Out

> > Building Microsoft Access Applications

> > Microsoft Office Access 2003 Inside Out

> > SQL Queries for Mere Mortals

> > http://www.viescas.com/

> > (Kirkland, WA)

> >

> >

> >

> >

> > -----Original Message-----

> > From: MS_Access_Professionals@yahoogroups.com

> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58

> > Sent: Wednesday, February 29, 2012 5:16 PM

> > To: MS_Access_Professionals@yahoogroups.com

> > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??

> >

> > That returns 51.

> > Thanks

> >

> > --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@>

> > wrote:

> > >

> > > ...and also:

> > >

> > > Asc(Right(ID,1))

> > >

> > > Best wishes

> > > Graham [Access MVP 1996-2012]

> > >

> > > > From: MS_Access_Professionals@yahoogroups.com

> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane

> > > > Sent: Thursday, 1 March 2012 11:38

> > > > To: MS_Access_Professionals@yahoogroups.com

> > > > Subject: [MS_AccessPros] Re: leading or trailing spaces/characters??

> > > >

> > > >

> > > > What are the results from:

> > > >

> > > > Len(Trim(ID))

> > > >

> > > > Len(ID)

> > > >

> > > > Duane Hookom

> > > > MS Access MVP

> > > >

> > > > --- In MS_Access_Professionals@yahoogroups.com, "glcass58" <glcass58@>

> > > wrote:

> > > > >

> > > > > I can't figure this out.

> > > > >

> > > > > select id from table where id = "mc63" does not work

> > > > > select id from table where id like "*mc63*" does

> > > > >

> > > > > I tried Trim([id]) and Replace([id]," ","") but they did not help.

> > > > >

> > > > > Any assistance would be greatly appreciated!

> > > > >

> > >

> >

> >

> >

> >

> > ------------------------------------

> >

> > Yahoo! Groups Links

> >

>

>

>

>

> ------------------------------------

>

> Yahoo! Groups Links

>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/