textbox format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Will I put this in the code?
Thanks

Rook


Bob Phillips said:
You can use

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


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
That depends upon your design, where you want the date formatted.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter a date in DD-MM-YYYY format 2
Isdate, checking Formatting too e.g. dd/mm/yyyy 2
Getting MM-DD HH:MM out of Julian date 4
date format convert 2
convert date 1
Excluding Friday & Saturday from the calculation 1
Format Combo Box 4
Date Format Problem. 2

Back
Top