#error message in control box in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waspfiat - 14 Mar 2006 07:13 GMT

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?

Reply to this Message

Andrei STROE - 14 Mar 2006 13:16 GMT

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?

Reply to this Message

Waspfiat - 14 Mar 2006 16:21 GMT

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")
[quoted text clipped - 7 lines]
> > Can anyone tell me why I'm getting the error message instead of the date I
> > specify when prompted to?

Reply to this Message