Yes, this is very acceptable and it works great...I seem
to be having another problem though not crucial but maybe
you would know why..
I have set up the Before Event
to validate my data when the record is saved but when I
enter an Input Mask of \B\C00000 in the Asset_Num field
and the user enters the 5 numbers which is correct the
Msgbox from the Before Event is being displayed when you
try to save the record and it
shouldn't be cause it meets the validation. It may be
another glitch but when I change the Input Mask to LL00000
I don't get that message and it lets me save the record.
Also, I have the Default Value set to "BC". I can have
only the default set with no input mask but then how do I
enforce that only capital letters be entered in the field..
Thanks again for any help..