#error message in control box in report

[Guest]

I keep getting an error message '#error' showing in my text box in the print
view of my report. The expression used in the box is =[dd/mm/yyyy]![Date].
Can anyone tell me why I'm getting the error message instead of the date I
specify when prompted to?

 

[Guest]

Hello,
You could try using =Format(Date();"dd/mm/yyyy")
however if you are setting the textbox value from code and not edit it
through its properties\control source then use =Format(Date(),"dd/mm/yyyy")
instead

 

[Guest]

Hello,

I am trying to use the date field as a filter - so that I can print a report
with info from a given day - also so that when opening the report, the user
is prompted to enter a date.

How would I proceed with this?

Thanks for your help.

Hello,
You could try using =Format(Date();"dd/mm/yyyy")
however if you are setting the textbox value from code and not edit it
through its properties\control source then use =Format(Date(),"dd/mm/yyyy")
instead

I keep getting an error message '#error' showing in my text box in the print
view of my report. The expression used in the box is =[dd/mm/yyyy]![Date].
Can anyone tell me why I'm getting the error message instead of the date I
specify when prompted to?