date displaying as #Name? but looks fine on print preview

[antonyx]

a slightly annoying problem..

i open up a report from my form.. the report has 2 textboxes.. my user enters a start date and an end date..

im trying to display the date entered on my report using this unbound textbox..

=Format(CDate([Forms]![frmDriverAccounts]![txtstart]),"dd mmmm yyyy")

on the report preview it displays the date fine.. when i print it displays as

#Name?

its annoyin. ive made the textbox bigger.. and it doesnt display either.

im also using these dates as the query criteria.. like so.

Between [Forms]![frmDriverAccounts]![txtstart] And [Forms]![frmDriverAccounts]![txtend]

is this interfering with the date display?

i cant think why.

 

[Rich]

You have to keep the form open, though I do wonder why the Format and CDate functions are being used for something so simple?