textbox format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rook - 04 Sep 2006 06:10 GMT

Is it possible to format the text, eg. date (mm-dd-yyyy), in textbox of
control toolbox?

Reply to this Message

Bob Phillips - 04 Sep 2006 08:05 GMT

You can use

With Me.TextBox1
If IsDate(.Text) Then .Text = Format(.Text, "mm-dd-yyyy")
End With

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Is it possible to format the text, eg. date (mm-dd-yyyy), in textbox of
> control toolbox?

Reply to this Message

Rook - 04 Sep 2006 08:31 GMT

Will I put this in the code?
Thanks

Rook

> You can use
>
[quoted text clipped - 4 lines]
> > Is it possible to format the text, eg. date (mm-dd-yyyy), in textbox of
> > control toolbox?

Reply to this Message

Bob Phillips - 04 Sep 2006 10:15 GMT

That depends upon your design, where you want the date formatted.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Will I put this in the code?
> Thanks
[quoted text clipped - 9 lines]
> > > Is it possible to format the text, eg. date (mm-dd-yyyy), in textbox of
> > > control toolbox?

Reply to this Message

Rate this thread: