[RESOLVED] Another Date Formatting problem, please help me.

[ejpotpot]

Hi,

I'm stuck with this task. I have a text box named tb_StartDate and I would like to ask if this is possible to mask this field with this character " / / " when the user is on or is about to make an entry to this box:

Goods Issue Date : [ / / ]

Initially, my program has this format but only when the user leaves that date prompt:

Private Sub tb_StartDate_LostFocus()
  tb_StartDate.Text = Format(tb_StartDate.Text, "##/##/##")
End Sub

Thanking you in advance.

[dee-u]

Why not use a Masked Edit control instead?

[eranfox]

Hello ejpotpot,

Why not use a Masked Edit control instead?

go to project -> components -> check the Microsoft Edit Control

Best Regards,
ERAN

[dglienna]

Masked Edit control is a pain to work with. Why not just add a calendar control.
I show a small form with a calendar control when the user clicks on a textbox that is supposed to have a date in it. Then I put the date into the textbox when they exit the calendar form.

It is much easier.

[dee-u]

Masked Edit control is a pain to work with. Why not just add a calendar control.
I show a small form with a calendar control when the user clicks on a textbox that is supposed to have a date in it. Then I put the date into the textbox when they exit the calendar form.

It is much easier.

Why did you say that it's a pain to work with?

[ejpotpot]

Thank you guys !!!

Hello ejpotpot,

go to project -> components -> check the Microsoft Edit Control

Best Regards,
ERAN

[dglienna]

Because you have to enter leading zeroes, and can't tab thru. I'd prefer 3 textboxes to the masked edit control. It's not hard for the programmer, but is a pain for the user. Clearing the mask edit is a two step process as well.

[ejpotpot]

Thanks dglienna. Yeah your right, have to enter leading Os but anyway, my initial task has the solution.

Cheers to ya all!

Because you have to enter leading zeroes, and can't tab thru. I'd prefer 3 textboxes to the masked edit control. It's not hard for the programmer, but is a pain for the user. Clearing the mask edit is a two step process as well.

[dee-u]

Because you have to enter leading zeroes, and can't tab thru. I'd prefer 3 textboxes to the masked edit control. It's not hard for the programmer, but is a pain for the user. Clearing the mask edit is a two step process as well.

I don't get it, I never had a problem with the Masked Edit, could you provide a sample form?

[dglienna]

Try a masked edit box for an IP addresss. I think that was the project that convinced me that it wasn't worth it.

[dee-u]

I thought it's about date? I use it mainly for dates and never had problems with it... And what do you mean by "Clearing the mask edit is a two step process as well." How aer you doing it?

[masqazi]

dglienna, we need more info on problems with mask control, and what is the alternative to it.

i need mask edit for date, and yes, if user enter a single digit, then control should make it two digits on its own, by having leading 0. also, when user enter single digit, control should go to months place automatically....with or without mask edit ..how???