two spaces to one within a field how?

[techexpressinc]

fieldwithOnly1space: Replace([fieldwith2spaces]," "," ")

I am trying this but it is not working any good ideas on fine tuning it?

Thx
Russ

 

[MSAccessRookie]

fieldwithOnly1space: Replace([fieldwith2spaces]," "," ")

I am trying this but it is not working any good ideas on fine tuning it?

Thx
Russ

Your use of the replace() Function seems to be correct, but it looks like you are trying to replace one space with one space. I am thinking htat this is a type-o for this post, but in the event that it is not, try the following:

fieldwithOnly1space: Replace([fieldwith2spaces],[COLOR=red][B]"  "[/B][/COLOR]," ")

 

[techexpressinc]

the forum squeezes out the extra space

I have this

fieldwithOnly1space: Replace([fieldwith2spaces],"bb","b")

with the b being a space.

Rus

 

[MSAccessRookie]

the forum squeezes out the extra space

I have this

fieldwithOnly1space: Replace([fieldwith2spaces],"bb","b")

with the b being a space.

Rus

I should have thought of that. Your format is correct and I have no additional suggestions regarding your problem. As far as the forum goes, if you surround any text that is entered, with a Code tag pair, then the text will be displayed without space compression. (Note: Each of the lines below was entered in the exact same format)

This Line DOES NOT Have Code Tags

This     Line     DOES     Have     Code     Tags

 

[techexpressinc]

attached is the db with the example, no extra tables or fields just the basics.
Rus

 

[boblarson]

attached is the db with the example, no extra tables or fields just the basics.
Rus

In your sample the first part of the Replace function has THREE (3) spaces and the second part has TWO. Fix that and it works.

 

[techexpressinc]

Bob - You are correct. The two to one works!
I get to eat a little crow but get happy customers which pay my bills.

Thx for the help.
Russ

 

[boblarson]

Bob - You are correct. The two to one works!
I get to eat a little crow but get happy customers which pay my bills.

Thx for the help.
Russ

No problem. It is hard sometimes to tell how many spaces there really are in something. They aren't easily distinguished when next to each other

 

[Galaxiom]

the forum squeezes out the extra space.

Not actually the forum but the html rendering specification itself. All sequences of spaces in html are reduced to a single space.

The PRE (preformatted) tag can be used to render text as typed.