Userform format question

[Martha]

Hi,

I would like to display the current time in either a label
or textbox. Could you please advise how to format.

Thanks a bunch,

Martha

 

[mark]

Hi Martha,

Try this.

lblTime.Caption & Format(Time, "hh:mm AM/PM")

 

[Bob Phillips]

I think you mean

lblTime.Caption = Format(Time, "hh:mm AM/PM")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Martha]

It doesn't like the "&" but wotrks with "="

Thank you very much.

 

[mark]

It doesn't like the "&" but wotrks with "="

oops... sorry.

I copied that out of something I have here... in my case,
I wanted it to append the time to the existing caption...
therefore the &

But for you, yep... =

Glad you got it working.

Mark

 

[mark]

yep, that was it.

I went into one of my applications to be reminded of the
exact positioning of the AM/PM part, and forgot to edit
the post appropriately.

Oops.