#Num error in linked Sub Form...

[Cordury2]

I have a form (frmDates) that is linked to an Excel file that is updated every week. Eventually this will be a sub form that will populate three different dates.

However, when I view the form, it is showing "#Num" instead of the MM/DD/YYYY that is on the Excel file. I have doubled checked the Excel file and there are no times or other characters in it.

Any ideas?

Thanks,
Cord

 

[Crowley16]

what about the formatting of the cells on the excel file?

--------------------
Procrastinate Now!

 

[Cordury2]

Crowley,

I should have stated that, my bad. Yes, I have gone into the Excel file and formatted them to MM/DD/YYYY.

 

[Crowley16]

try converting them to a string on import, and the formatting the string to a date...

--------------------
Procrastinate Now!

 

[Cordury2]

Is that possible if the table is linked to an Excel file? I just go to File - Get External Data - Link Tables....

 

[Crowley16]

in that case, probably not...

but if you set the excel file's formatting to string, and validate in the excel file, then maybe that'll sort it...

--------------------
Procrastinate Now!