CODEWITHSUNDEEP
ms-accessvbams-access-2010ms-access-2007
Samjus
Samjus

Reputation: 675

Access 2010 Format Current Date In Report

I am using Mircosoft Access 2010 VBA to create a report. I am trying to use the current date and format it "mmmm dd, yyyyy".

I have a text box with the control source ="As of " & Format(Date(),"mmmm d"", ""yyyy") and format of Medium Date.

It works in Windows 2007 and it shows as "As of April 10, 2018". BUT if I run it in Windows 10 I get #Name?

Does Windows 10 do things differently then Windows 7? Am I missing something that I need to download (I.E. A library file?)

Upvotes: 0

Views: 90

Answers (1)

Samjus
Samjus

Reputation: 675

I re-compiled on a Windows 10 machine and received a missing or broken reference error for EXCEL.EXE version 1.7. I re-checked the excel references (Tool > References) and that fixed the issue.

Upvotes: 0

Related Questions