Input mask problem?

[Guest]

Hi everyone,
I have a marco that exports a report to excel format. When I open the excel
spreadsheet it states "File Error. Some number formats may have been lost."
I examined the spreadsheet and the only problem is my receiveddate field is
showing in number format. In my table design i did have an input mask of
99/99/0000;0;_ and thought this may be causing the problem. I took out the
mask but still get the same error. Can someone offer me a reason why this
may be happening and a possible workaround/solution? Thanks.

 

[Mark A. Sam]

I don't work with excel, but if this was me I would check not only the
formats on all the fields in the table, but the datatypes. It may be a
datatype in the Access table not acceptable for the usage in the
spreadsheet. For example, you have a text field in the Access table holding
date Values, but it isn't a Date type field. So check that the Data fields
are compatible.

God Bless,

Mark A. Sam