Hi,
Can anyone tell me how to add a text box to the report header/footer that
would prompt the person running the report to enter their name or the ending
date of the report, etc. I'm on a deadline for today at noon and am starting
to get worried.
I posted the below yesterday the only option of specifing the data is
numbers and I don't always need to use a date. I searched google and only
came up with defining types in queries. This is not from a query, it is for
a free form field in the report header or footer.
This question gets asked a lot. You need to specify the data types of the
parameters. If you can't figure this out, GOOGLE is your friend (or come back
here).

Signature
Duane Hookom
Microsoft Access MVP
"awalker" wrote:
> Hi,
> I have a report that pulls from a cross tab that comes from a make table
> querey. In the report I need the ability to have a text box where the agent
> can enter certain data when promoted. For example =[Enter End Date] or
> =[Enter Reporter Name] However, when I enter this into a text box I am
> recieving a error that states that it is not reconginzed as a valid field
> name or expression. How do I get around this?
Brendan Reynolds - 07 Mar 2008 15:29 GMT
> Hi,
> Can anyone tell me how to add a text box to the report header/footer that
[quoted text clipped - 20 lines]
>> recieving a error that states that it is not reconginzed as a valid field
>> name or expression. How do I get around this?
This is a quick-and-dirty solution, and probably not how I'd do it in a
production app, but you did say you were in a hurry. You can set the
ControlSource property of the text box to an expression that uses the
InputBox function to prompt the user for the text. Something like ....
=InputBox("What do you want in the header?")

Signature
Brendan Reynolds
Evi - 07 Mar 2008 15:37 GMT
There's something that doesn't make sense here.
I can't find your previous posts so sorry if this doesn't help.
Put a text box into the place where you require it. Click on Text Box on the
Tool Box toolbar. *Don't just use an existing Control that might be linked
to a field*. Give your text box a name that ISN'T the name of one of the
fields in your report.
In the text box type your question after an = and between box brackets
=[What is your name]
When the user fills this in, his name will appear in the report.
If you don't want the report to open unless the user fills in his name, then
you will put code into the Report's OnOpen event
It will say
If IsNull([YourTextBoxName]) Then
'substitute the real name of your text box
DoCmd.Close
End If
Note that all this does is put a name into a box, it doesn't filter the
report, but you didn't ask for that.
Evi
> Hi,
> Can anyone tell me how to add a text box to the report header/footer that
[quoted text clipped - 21 lines]
> > recieving a error that states that it is not reconginzed as a valid field
> > name or expression. How do I get around this?