Input mask problem?

S

scott04

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.
 
M

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
 

Ask a Question

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.

Ask a Question

Similar Threads

Input Mask for General Date/Time 1
Input Mask 0
date input mask 0
Invalid date/time value 0
Input mask works not reliable 1
Date input mask 1
Input Mask For Phone Number 4
date+time input mask 3

Top