Limit Max Input Values

[jereece]

I have a grading form where we grade reports on a 0 to ___ scale. The scale varies for each section of the report. I have a field for each section that specifies the max value. So for example for the Corrective Action section I have a grade field and I also have a MaxValue text box to indicate the max points that section can get. What is the best way to prevent someone from accidentally entering a value outside the max value? Is this handles on the form itself or on the design of the table field?

Thanks,
Jim

 

[neileg]

Several ways. Easiest from a user point of view is probably a list box or combo box that only contains valid values. Or you could use the validation rule on the text box. Or some VBA code on the AfterUpdate event of the text box.

 

[jereece]

I tried a validation rule like the one below but it does not work.

[PI_Score]<[PI_Max]

I would really like to say the score has to be between 1 and [PI_Max]. Any ideas what I may be doing wrong?

The combo box will work but it does not prevent someone from manually entering a number that exceeds the max. I would like to totally prevent that from happening.

Any suggestions?

Thanks,
Jim

 

[neileg]

I tried a validation rule like the one below but it does not work.

[PI_Score]<[PI_Max]

I would really like to say the score has to be between 1 and [PI_Max]. Any ideas what I may be doing wrong?

What is [PI_Max]?

The combo box will work but it does not prevent someone from manually entering a number that exceeds the max. I would like to totally prevent that from happening.

If you set the LimitToList property to Yes (which is the default setting), then this can't happen.