Suppress message on manual print

O

Opal

I have created a chart report that opens based on user selected
parameters from a form. However, if the user does not select
certain parameters, I have included the following in the control
source of the combo box on the form:

=IIf(IsNull(Forms!frmSearchrpts!cboFilter1),"All",Forms!frmSearchrpts!
cboFilter1)

The only problem is that this combo box is a numeric field and "All"
is text
so when I try to manually print the report I get the following warning
message:

"The value you entered isn't valid for this field"
"For example, you may have entered text in a numeric field......"

Is there anyway to suppress this message when the report is printed
manually?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart problems 13
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Dynamic Naming of Form Button 3
Page numbering with Merged Document and IF statements 1
Suppress printing 2
Suppress Text on a Report 1
Report Input Parameters 2
Using two combo boxes to filter a form 1

Top