validation text
1 sub-question across 1 paper, 4 marks total.
Computer Applications Technology 2026
Restrict GrantAmount to values between 5 000 and 50 000 and provide a meaningful Validation Text if violated.
Show answerHide answer
Click GrantAmount, then:
Validation Rule: >=5000 And <=50000
Validation Text: Grant amount must be between R5 000 and R50 000.Validation Rule: >=5000 And <=50000
Validation Text: Grant amount must be between R5 000 and R50 000.Why this earns the marks
marks for lower limit, upper limit, joining them with And (not Or, which accepts everything), and a clear message — each boundary of the range is an independently checkable condition. Joining two bounds with Or rather than And is a classic logic trap: "value >= 5000 Or value <= 50000" is true for almost any number (every number is either above 5000 or below 50000, or both), so the rule would accept values it was supposed to reject. Type numbers without spaces in the rule — Access parses the Validation Rule as an expression, and an unexpected space can break how it's tokenised. Between 5000 And 50000 is also correct, since it's Access's built-in shorthand for exactly the same two-sided range check. The message must tell the user what is wrong, so "Error" is not meaningful: Validation Text exists specifically to explain which rule was broken and what's expected instead, which a generic word doesn't do.