Nonbreaking space as a constant

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bear - 07 Dec 2007 20:02 GMT

How can I specify a nonbreaking space in a constant? I'd like to accomplish:

Const strColon As String = ":" & Chr(160)

But one can't use the Chr function when dimensioning. The higher idea is to
isolate the delimiter used at the beginning of the code for easier
maintenance.

Bear

Signature

Windows XP, Word 2000

Reply to this Message

Helmut Weber - 07 Dec 2007 21:21 GMT

Hi Bear,

just type it in the editor,
numlock on, alt 0160

Const strColon As String = ": "
MsgBox Asc(Right(strColon, 1)) ' 160

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

Reply to this Message

Bear - 07 Dec 2007 22:05 GMT

Helmut:

Thanks! How simple -- but how potentially deceptive. I'm going to have to
comment that to remember that it's not a space.

Bear

Signature

Windows XP, Word 2000

Reply to this Message