formating textbox

[JG]

Hello,
I am trying to format a textbox to
display a date as 05/10/02, but it covert it to the excel numbering of dates 46232 how do I change this .....Thanks

 

[Brian from Maui]

JG,

I've been trying to replicate your problem with the text box and can't seem to get Excel to express the date as 46232. Are you using the text box from the Drawing toolbar?

 

[dk]

Hi,

What's your code? You can use something like this but it depends on how your form is set up:-

Private Sub TextBox1_AfterUpdate()
Me.TextBox1.Text = Format(Me.TextBox1.Text, "mm/dd/yy")
End Sub

Regards,
Dan

 

[JG]

Maybe thats my problem I haven't written any code could someone give me a basic example of formatting a textbox .....Thanks