Creating comments box

Joe Small

New member
Local time
Yesterday, 17:57
Joined
Oct 14, 2010
Messages
6
Hello all, Access 2007 forms question!!
need some help here. I have created a user form to enter students grades.
So there is a textbox to enter Total points possible:
and another textbox to enter Points earned by student:
I have also created a coment box to enter any explanatory comments. I want to be able to prompt and force user to enter comments when a students percentage[points earned/total points] is below a certain number.
How do I do that? what is the code or set of properties for comments box to achive this result.

Pls help.
Thank you
 
If Points < X and Trim(Comments & "") = "" Then
Comments required
End If

For brevity only
 

Users who are viewing this thread

Back
Top Bottom