"Enter Parameter Value" not wide enough

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gina K - 05 Apr 2007 20:28 GMT

When I try to open a particular report I'm getting the "Enter Parameter
Value" box. However, the box is not wide enough for me to see exactly what
parameter it's asking for. I tried to drag the box to a bigger size, but I
can't seem to. Is there any way to enlarge this box so I can see exactly
what I'm being prompted to enter (and find where my mistake lies)?

Thank you.

Reply to this Message

Scottgem (MVP) - 05 Apr 2007 21:03 GMT

If you didn't plan on using a parameter, that means that Access can't
find some value in your query. What does the part of the box you can
read say?

Signature

HTH
Scott<>
Microsoft Access MVP 2007

> When I try to open a particular report I'm getting the "Enter Parameter
> Value" box. However, the box is not wide enough for me to see exactly what
[quoted text clipped - 3 lines]
>
> Thank you.

Reply to this Message

Ofer Cohen - 05 Apr 2007 21:06 GMT

You can create a form with three obects

1. Lable that describe the parameter the user need to input
2. A text box where the user select the parameter
3. A button that open the report with a filter using the parameter from the
text box

Dim MyCriteria As String
MyCriteria = "[FieldNameInTable] = " & Me.[TextBoxInForm]
Docmd.OpenReport "ReportName" , , , MyCriteria

Note: If the criteria is on a text field use
MyCriteria = "[FieldNameInTable] = '" & Me.[TextBoxInForm] & "'"

Signature

Good Luck
BS"D

> When I try to open a particular report I'm getting the "Enter Parameter
> Value" box. However, the box is not wide enough for me to see exactly what
[quoted text clipped - 3 lines]
>
> Thank you.

Reply to this Message

Ofer Cohen - 05 Apr 2007 21:20 GMT

Sorry, I didn't undestand your question, please ignore my post.

Signature

Good Luck
BS"D

> You can create a form with three obects
>
[quoted text clipped - 17 lines]
> >
> > Thank you.

Reply to this Message

Ofer Cohen - 05 Apr 2007 21:30 GMT

In the report check first if the error is in the report control source or
with the report itself

1. Run the report control source separatly, if you get the error check which
filed is in the query but not in the table

2. Check the reprot text boxes, it could be that one of the fields in the
table that the report is bounded to was deleted but it wasn't removed from
the report.

3. If the error caused somewhere in the code in the report, you can press
Ctrl+Break to see where the error is

Signature

Good Luck
BS"D

Reply to this Message

julie@cornatzer.net - 25 Jun 2007 22:53 GMT

>When I try to open a particular report I'm getting the "Enter Parameter
>Value" box. However, the box is not wide enough for me to see exactly what
[quoted text clipped - 3 lines]
>
>Thank you.

hmm... curious

Reply to this Message