Editing formatted date in textbox

  • Thread starter Thread starter Adrian Jansen
  • Start date Start date
A

Adrian Jansen

Access 2002

When using a textbox formatted as short date to edit data stored in a table
as Date/time, I notice that while the format is correct when you just
display the data, as soon as you enter the field, the format changes to show
the full date-time info. This gets confusing for users, who expect to see
and edit only the date. Have I gor something set wrongly, or is this normal
?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanks John.

And I hate input masks, esp for dates, because it constrains the user to
just one format. Its very nice to be able to input dd-mon-yyyy, or dd/mm/yy
and have Access interpret it properly.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
And I hate input masks, esp for dates, because it constrains the user to
just one format. Its very nice to be able to input dd-mon-yyyy, or dd/mm/yy
and have Access interpret it properly.
Click to expand...

Oh, I agree. I never use a mask unless I absolutely must (client
insistance) and just ignore the time portion of dates.
 
Back
Top