Problem of input mask in VBA text box ?

Question

There is a problem in VBA text box while filling input mask property:

I am trying to make the combination of date and time:

Hence i put it like below:

00/00/00;0;_00:00;0;_

But while running the application, i am only getting 00/00/00 (Date).

But i remember, i got the result as like 00/00/00 00.00 as expected when i first put the expression as like above;

but now i am not getting it :-(

Answer 1

The InputMask property can contain up to three sections separated by semicolons (;)

Your mask should be like this:

"00/00/00 00:00;0;0"

or

"00/00/00 00:00;0;_" // to display it like __/__/__ __:__

Answer 2

Why not just use the built in "General Date" format? I've found over the years that input masks are very restricting and basically a pain. Although it's been so long since I've used them that I don't recall the details of why I despise them.

This also has the benefit of respecting the users choices of regional date format. For example I always use yyyy-mm-dd format.

Also a client had a situation where the date format was decreed to be Medium Date on all fields. Which is dd-mmm-yy. It later turned out that in a table of 100K records there were twelve dates before 1900. They had simple had something extra keyed in in the year so Windows/Access interpreted those dates as being in the 3rd or 5th century or whatever. Now these dates weren't used in any kind of calculation so it wasn't a big deal. SQL Server upsizing to small date/time fields didn't appreciate those though.