input mast

Got the following to turn into a input mast

130800z Jan 06
Which means in layman's turns, the first two digits are the date for
today,
the following 4 digits are the time, the z has to remain, well you can
work
out the rest,
What I have got so far is the following

000000z LLL 00

which works
but what I need to know how to do is simplify things a little is how to
auto
generate the date and time and month and year, in the above format



any ideas


fie

Fie,

I don't think you need an Input Mask for this. Depends a bit when this
is going to happen. If it's when a new record is created, you could set
the Default Value property of the control on your form to this...
Format(Now(),"ddhhnnz mmm yy")

--
Steve Schapel, Microsoft Access MVP


Fie wrote:
Got the following to turn into a input mast

130800z Jan 06
Which means in layman's turns, the first two digits are the date for
today,
the following 4 digits are the time, the z has to remain, well you can
work
out the rest,
What I have got so far is the following

000000z LLL 00

which works
but what I need to know how to do is simplify things a little is how to
auto
generate the date and time and month and year, in the above format



any ideas


fie