Input masks are not the same as display formats. Input masks constrain how
users must input a value. They can get in the way if the user wants to
enter a date in a (still-acceptable by Access) way that doesn't match the
input mask.
MS Access stores date/time values as whole numbers (days since a specific
date late in 1800's) and decimal fractions (fraction of a day - .5000 =
noon).
How you have your form DISPLAY that date/time value depends on the Format
property you set in the control on the form.
Input masks are not the same as display formats. Input masks constrain how
users must input a value. They can get in the way if the user wants to
enter a date in a (still-acceptable by Access) way that doesn't match the
input mask.
MS Access stores date/time values as whole numbers (days since a specific
date late in 1800's) and decimal fractions (fraction of a day - .5000 =
noon).
How you have your form DISPLAY that date/time value depends on the Format
property you set in the control on the form.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
