>I want to display datetime() in report in this format: 4/1/1999 3:21 PM, how can I do that? And other little problem: I change a backcolor of one field in detail (in order to underline it), in design mode I see this, but in the Preview or Print I don't see anything.
>
> Could somebody help me?
>
> Thank in advance.
It's very easy. Add a textbox to a report, but instead of binding it to a field, bind it to DATETIME(). This will pull the current info when printing. To format AM/PM, look at the SET HOURS command.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer