S
sword856
Hello all, I have an issue with a form I use.
There is a date field on my form that I need not to be further out
than this fiscal year, so I set the field Validation Rule to
"<#10/1/2008#". This rule works, as it prevents any entry of dates
later than that. On my form, it also prevents people from entering
dates later than that. The message that pops up, however, is a visual
basic error message. "Run-Time Error '3316': MyValidationText".
This is because I am using a calendar control to update the field. I
have a combo box that OnMouseDown, the calendar becomes visible and
gets focus. After selecting a date, that value is sent to the combo
box and the calendar disappears. It is when the combo box value is
set to the calendar value that the validation rule is checked and the
error occurs. Since the error occured during a VB process, the VB
error box comes up.
This is very undesirable.
That box has the option to "Debug". I DO NOT want users to be able to
go to my code and edit things. This could be catastrophic. I need to
be able to validate the date entry without that sort of error message,
while at the same time still using the calendar control. I tried
using the validation rule in the control's properties when editing the
form, but no matter what I put in it doesnt check that rule when
entering data. Help would be much appreciated.
TIA,
George
There is a date field on my form that I need not to be further out
than this fiscal year, so I set the field Validation Rule to
"<#10/1/2008#". This rule works, as it prevents any entry of dates
later than that. On my form, it also prevents people from entering
dates later than that. The message that pops up, however, is a visual
basic error message. "Run-Time Error '3316': MyValidationText".
This is because I am using a calendar control to update the field. I
have a combo box that OnMouseDown, the calendar becomes visible and
gets focus. After selecting a date, that value is sent to the combo
box and the calendar disappears. It is when the combo box value is
set to the calendar value that the validation rule is checked and the
error occurs. Since the error occured during a VB process, the VB
error box comes up.
This is very undesirable.
That box has the option to "Debug". I DO NOT want users to be able to
go to my code and edit things. This could be catastrophic. I need to
be able to validate the date entry without that sort of error message,
while at the same time still using the calendar control. I tried
using the validation rule in the control's properties when editing the
form, but no matter what I put in it doesnt check that rule when
entering data. Help would be much appreciated.
TIA,
George