inset text box that requests information

[smile]

Hi, I need to insert an empty textbox into a report with a label "custom words etc." and I want to get a popup where I can enter the phraze. When I enter the phaze I neet it to be displayed in my report.

This way I could change it everytime I preview then print a report.

Hope you ondertood

 

[Jibbadiah]

I hadn't tried this before, but it seems to work.

Create a query that has all of the normal criteria that you want to show in the report.

Then add one addition field to the query of...
VariableField: [Input your Variable text Here]

Then add the variable text field to heading section of your report.

This way it should prompt you just before the report opens.

A basic test seems to work... see how you get on.

 

[smile]

I hadn't tried this before, but it seems to work.

Create a query that has all of the normal criteria that you want to show in the report.

Then add one addition field to the query of...
VariableField: [Input your Variable text Here]

Then add the variable text field to heading section of your report.

This way it should prompt you just before the report opens.

A basic test seems to work... see how you get on.

The problem is that I create a huge report using access 2007 beta 2. it is a customised report. I created it from query. Now I had to customise it using access 2007 beta 1 as beta 2 does not allow data from queries only tables.

So I done my report and forgot that supid thing to include one row from query that I could change (see my number to words thread).

I can include a textbox in PageFooter only. And need access to ask me for what i want to put there before opening the form.

The stupid thing is that if I add aditional field to my query access does not see it. I overcomed this by making my report with wizard beta1 and totally re-customizing it.

 

[Rich]

Well if the beta version doesn't work use a version that does

 

[smile]

Well if the beta version doesn't work use a version that does

and what version may that be?

 

[Rich]

Access 97 seems to be about the best so far