1. You should NOT be entering data directly into the tables ... and I assume
that's what you mean by "cells" . Remember, this isn't Excel ...
2. The Format property in the table is the default Format that will be used
when you build a form/report and include that field in the form/report.
3. Use the InputMask property of your forms to control how the user should
input these values
Date values in Access are stored as Long Integer values ... look at your
table without formatting applied after entereing a few date values and
you'll see what I mean. They are in the format of mm:dd:yyyy hh:mm:ss AM/PM.
Rik said:
I am trying to formnat a cell to the following format Jun03. No matter
what I have tried so far I can not get it so I can make the date appear that
way. If I put a date in and then change the format it will appear that way
but if I have the format the way I want it and the field olny asks for month
and year then when I put the month and year in it changes the year to day
and then 03 auto shows as the year. any help would be greatly appreciated
