Remove spaces text field

  • Thread starter Thread starter paulmitchell507
  • Start date Start date
P

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
 
paulmitchell507 said:
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/
 
Paul,

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

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

--
Steve Schapel, Microsoft Access MVP


paulmitchell507 said:
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
 
It is not googlemail its gmail ok

lizhenglang said:
Steve Schapel said:
Paul,

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

--
Steve Schapel, Microsoft Access MVP


paulmitchell507 said:
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
 
÷Ðñ said:
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
Steve Schapel said:
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
 
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
Steve Schapel said:
Paul,

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

--
Steve Schapel, Microsoft Access MVP


paulmitchell507 said:
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
 
Andrew, I don't understand your question but I can help. What is it you
need help with.

God Bless
Laurie

lizhenglang said:
Steve Schapel said:
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, do you need help? I'm here

God Bless
Laurie


÷‹ñ·¢â€Ï€â€¹Ã‚ÎÅ◊é‹Åâ
lizhenglang said:
Steve Schapel said:
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
 
Do you need help, God is here for all of you. Just ask and it will be
granted.

God Bless
Laurie


÷Ãñ said:
÷Ãñ·¢²¼ÃÂÎÅ×éÃÅâ
lizhenglang said:
"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
 
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

lizhenglang said:
Steve Schapel said:
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
 
What is your question, I can help
God Bless
Laurie


Steve Schapel said:
Paul,

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

--
Steve Schapel, Microsoft Access MVP


paulmitchell507 said:
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
 
lizhenglang said:
Steve Schapel said:
Paul,

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

--
Steve Schapel, Microsoft Access MVP


paulmitchell507 said:
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
 
lewis i need help for a hot mail
andrew lewis said:
lizhenglang said:
Steve Schapel said:
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
 
÷Ðñ said:
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
Steve Schapel said:
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
 
matthew said:
÷Ðñ said:
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
"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
 
matthew said:
÷Ðñ said:
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
"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
 
you are you
to night

matthew said:
÷Ðñ said:
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
"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
 
ok taxt me
John Smith said:
lewis i need help for a hot mail
andrew lewis said:
lizhenglang said:
"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
 
Back
Top