Unable to display non-breaking hyphen in VBA form

  • Thread starter Thread starter Dave Jenkins
  • Start date Start date
D

Dave Jenkins

Running on Office 2007 SP 1, Windows XP SP 3.

I am displaying text values in a textbox field on a form. When the text
contains a non-breaking hyphen (chr(173)) the hyphen doesn't display in the
form field. It's definitely in the data.

Do I have to do something special in the form field definition to allow the
hyphen to display?

Actually, you can reproduce this yourself by creating a simple form with a
textbox, and enter the 173 character into the text property.

Go here to see a screenshot of editor results of what I'm talking about:

http://screencast.com/t/xIazufU1G8o

Thanks
 
At first I thought this to be a font issue but no, changing fonts does not
help. VBA TextBoxes can break long lines if you set MultiLine and WordWrap
as True. But I find that it breaks even at a non-breaking hyphen. It does
show the non-breaking hyphen when it breaks the line though. It also hides
the non-breaking hyphen when line goes back to unbroken state (when you
delete some characters).

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html
 
Back
Top