I am a newbie! I've designed an Access database form to track employee time spent with each client. The employees want to be able to enter an even time, such as 4
o into a date field using the short cut (4 . When they enter it without the trailing zeros, they get the message; "The value you entered isn't valid for this field." Is there anyway to write into code and let VBA complete the entry?
I tried using an errorHandler but it doesn't seem to catch it.
o into a date field using the short cut (4 . When they enter it without the trailing zeros, they get the message; "The value you entered isn't valid for this field." Is there anyway to write into code and let VBA complete the entry? I tried using an errorHandler but it doesn't seem to catch it.
