Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Insert a non-space space in Word and Access


  • Please log in to reply

#1
johnbfdma

johnbfdma

    Member

  • Member
  • PipPip
  • 19 posts
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


  • 0

Advertisements


#2
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
It's called a Non-Breaking Space (in Word), and can be inserted by typing Ctrl+Shift+Spacebar.
  • 0

#3
johnbfdma

johnbfdma

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts
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!
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP