Printing Formula

[daveUK]

Hi Guys

I have several reports, all of which need to be printed out. In order to make the reports 'more meaningful' I have a textbox on the report header that shows the type of report and the dates.

I've used the following code in the control sourceof the txtbox:

="Report For " & [Forms]![FrmDiscountSearch]![TxtStart] & " To " & [Forms]![FrmDiscountSearch]![TxtEnd]

This displya the start and end date of the report BUT when I print the report out all I get is:

Report For To
i.e. no formula.

Is there anyway of printing the formula?

Dave

 

[suepowell]

Hi,
I think, in order for the values from the forms to show, the form needs to be open when you print, this might be the cause of the problem.

I have done exactly what you are trying to do in an access 97 database, so you are on th right track.

As a side issue, I have found that if you put a bound field onto a report or form, then change the datasource to an expression, it gives an error, but if you delete the bound field and add an unbound textbox, then change the datasource to be the same expression, it works fine. I'm sure there is a reason for this, but it is not obvious to me!

Hope this helps

Sue

 

[daveUK]

Thanks for the reply Sue, but unfortunately it still won't print properly with the report open.

 

[daveUK]

It's ok I managed to get it sorted. Thanks for your help Sue.

Dave