How do I find more than 1 space between words in a text field, th.

[Guest]

I have several text fields that contain 1 or more spaces between words. How
do I use Find and Replace to locate two or more spaces together and replace
two or more spaces with one space?

 

[John Vinson]

I have several text fields that contain 1 or more spaces between words. How
do I use Find and Replace to locate two or more spaces together and replace
two or more spaces with one space?

I'm not sure you can with Find and Replace - have you tried just
typing two blanks in the Find line?

In an Update query you can update the field to

Replace([fieldname], " ", " ")

Keep running the query repeatedly until it has whittled down the
fields with " " to a single blank.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps