I don't really know if you get me. But it would not be needed to
done in the VBA codes of the report but on the
design view of your tables itself. :)
I've meant format property of report field which could be set in report design view.
A date supposed to appear in the desired format in report, isn't it?
So, there is no reason to make changes in the table design. Changing table field format property may affect report field format property in two ways:
- when you set field property in table design view Access will display smarttag suggesting the changes to be passed to all correspondent objects (forms, reports etc)
- when your create a new report from table/query Access will set the report field properties according to that in table
Format of report field is not the same as format in table view field.
This is what I've meant. Sorry if was unclear.
P.S. Of course, my suggestion in msg#2 is not an optimal one.