[johnbfdma]

I have two problems that I think may the same problem:

In Word, I want to keep two words together so that they won't get separated by wrapping at the margin.

In Access, I am using the TRIM function to remove extra spaces from several concatenated text fields, BUT I want to maintain extra space between two of the fields, despite TRIM's efforts to remove extra spaces.

I think that the answer to both those issues may be something I believe may have once been called a forced or required space. I think it is a non-displayable / printable character that will hold space in the text, but will not be treated as space by word wrap in Word or by Trim in Acess.

I think I've seen it some e-mails that I have edited with Word with the non-printing characters turned on - it looks like a degee symbol. I have pasted it between here| |and here and have inserted it into the attached Word doc.

Am I on the right track, what is the charater?

Attached Files

•  forcedspace.doc   25KB   33 downloads

[Advertisements]

It's called a Non-Breaking Space (in Word), and can be inserted by typing Ctrl+Shift+Spacebar.

[piper]

It's called a Non-Breaking Space (in Word), and can be inserted by typing Ctrl+Shift+Spacebar.

[johnbfdma]

Great! It worked in Word as you described and I was able to use it in Access by copying the character from Word and pasting it into Access!

Thanks!