Report text box for date(=Date()) fails in Access 2007 Runtime. Perfect in AC2007 Full version.

[Edward_]

In both cases I'm using an MDE.



I have a text box on a report header, with the Control Source value set to: =Date(), Format: Long date, control name: Date.
Running with Access 2007 full version (Win 7 Pro), this field ends up with the correct long date on the report as desired, but using Access 2007 runtime (Win 10), the result is: #Name?

A use of =Now() for this purpose (in page footer) seems to work with either Access RT or full (used in Page Footer).
Is this a legacy use of =Date()?

Any advice appreciated.

[pbaldy]

Smells to me like a reference issue. Date() is still perfectly valid, but a reference problem can cause odd issues like this.

[CJ_London]

control name: Date

this might be your problem, should not use reserved words for table/field/control names.

[Edward_]

I changed the field name to txtDate and the control source to: =Now().
All is well.

Thanks

[pbaldy]

I'm curious if it works with Date() now, since you said it worked with Now() anyway.

I didn't notice that the control had the same name, which could also have caused the problem.

[CJ_London]

changed the field name to txtDate

presume you mean the control name?