var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date issue on reports
I tried putting automatic fields on my report: insert...date & time
This creates a textbox: '=Format(Date(),"Short Date")
but it gives a '#name?' error.
I can use '=now()', but I can't get it in the right format (dd/mm/yyyy).
Does somebody know the cause of the error and the resolution?
What you have tried should work.
In a text box control on a report, put this in "Control Source" property:
Even this works;
Try it again.
I can't type in the text box, it says
'The function you entered can't be used in this expr
* You may have used a DoEvents, LBound, Ubound, Spc, or Tab function in an expression
*You may have used an SQL aggregate function, such as count in a design grid or in a calculated control field'
Not sure how you are trying to do it, so I have attached an example showing that putting a formatted date in a text box in a report works.
Thanks, but that's the way I did it... I only have the problem on a specific pc, with AC97.