Date Format Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

singeredel - 28 May 2006 17:51 GMT

Is there a way to include a non-breaking space between the month and day in
the following date format code so that the month and day do not separate when
they appear at the end of a line?

ScheduleDate1 = Format(ScheduleDate, "mmmm dd, yyyy")

Thanks...

Signature

singeredel (Julie)

Reply to this Message

Greg Maxey - 28 May 2006 18:04 GMT

Include the non-breaking character in your format definition:

Sub Test()
Dim SDate As Date
SDate = Now
Selection.Range.InsertAfter _
Format(SDate, "mmmm" & Chr(160) & "dd," & Chr(160) & "yyyy")
End Sub

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Is there a way to include a non-breaking space between the month and
> day in the following date format code so that the month and day do
[quoted text clipped - 3 lines]
>
> Thanks...

Reply to this Message

Helmut Weber - 28 May 2006 18:04 GMT

Hi Singeredel,

looks odd, but seems to work:

Selection.TypeText _
Text:=Format(Now, "mmmm" & Chr(160) & "dd," & Chr(160) & "yyyy")

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Reply to this Message

singeredel - 29 May 2006 21:19 GMT

Thank you both. I didn't realize I could break up the format with the
character code. That works.

Signature

singeredel (Julie)

> Is there a way to include a non-breaking space between the month and day in
> the following date format code so that the month and day do not separate when
[quoted text clipped - 3 lines]
>
> Thanks...

Reply to this Message