Format Date error in Control Source of MS Access 2000
Posted on 2007-10-12
Here is a puzzlement.
I have an MS Access database and am using on a report in the Control Source the default to populate a textbox field with the current date in long format and am using the plug and play of MS access to populate the control source entry. The Code is
=Format(Date(),"Long Date") & " " & Format(Time(),"Long Time")
Now here is the kicker. This works on my computer and a user computer and gives them the current date in the report. However on two other user computers it gives them an error of #Name?
However a previous verision of the MS Accessdata from a couple of months ago prior to some edits that where done works and does not give an error.
Previous and current does not work on some computers.
Pervious and current does work on other computers.
The code for both versions is the same.
Could this be an update issue with MS Office.?