Remove spaces text field

[paulmitchell507]

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[Hunter57]

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

Hi Paul,

Use the Replace Function. This will replace every blank space in the string:

strZipCodes = Replace(strZipCodes, " ", vbNullString)

Best Regards,
Patrick Wood
http://gainingaccess.net/

 

[Steve Schapel]

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

 

[lizhenglang]

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[amclean]

It is not googlemail its gmail ok

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[imani whitehead]

÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[÷Ðñ]

÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[Laurie Burrell]

Andrew, I don't understand your question but I can help. What is it you
need help with.

God Bless
Laurie

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[Laurie Burrell]

Paul, do you need help? I'm here

God Bless
Laurie

÷‹ñ·¢â€Ï€â€¹Ã‚ÎÅ◊é‹Åâ

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[Laurie Burrell]

Do you need help, God is here for all of you. Just ask and it will be
granted.

God Bless
Laurie

÷Ãñ·¢²¼ÃÂÎÅ×éÃÅâ

"Steve Schapel" <[email protected]>
??????:%[email protected]...
Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[Laurie Burrell]

What is your question? Gmail is just another format to email, it is free
and easy

I can help, just ask
God Bless
Laurie

It is not googlemail its gmail ok

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[Laurie Burrell]

What is your question, I can help
God Bless
Laurie

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[matthew]

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP

My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

ok 555

 

[John Smith]

lewis i need help for a hot mail

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[matthew]

÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢

Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

hi do you need my help

 

[markhenry]

÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢

"Steve Schapel" <[email protected]>
??????:%[email protected]...
Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

hi do you need my help

 

[Ruby Moten]

÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢

"Steve Schapel" <[email protected]>
??????:%[email protected]...
Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

hi do you need my help
This group`s under the Curse of Lord Shiva,.immediately!Who told you to
hack and ssteal my info?Did you think the Black Madonna has no power?Did
you all globally think there was no consequences to be met? Well,I live by
the Sowing and Reaping Law of God,and this invasion of my privacy and
intellectual property has deadly endings.God said-"touch not Mine
Anointed",since when ddid touching a God-called Saint,not feed for Divine
Retribution?Did you all read my group posts and blogs?Did you think I made
them up?If my computer`s not restored this seven days coming,none of you
will escape the pestilence I called to clean my Eternal Empire.I`ve had
enough of you aliens defiling this Empire.They killed Lord Shiva when they
euthanized 2PAC-the THUG PRIEST,and I`m still,KALI-the Black Madonna.Go to
geocities and look up-Shiva is the Lord of the Sabbath,you`ll see that we
preceded Columbus,and returned in our AFTERLIFE.You all have seven days to
restore my pc or die.Maharanee Kali

 

[annmarie mc williams]

you are you
to night

÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢

"Steve Schapel" <[email protected]>
??????:%[email protected]...
Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

hi do you need my help

 

[aly]

ok taxt me

lewis i need help for a hot mail

"Steve Schapel" <[email protected]>
??????:%[email protected]...
Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul

 

[John W. Vinson]

ok taxt me

Aly, please do NOT use these working newsgroups for your private
conversations. Take it to EMail.