Form using a column of short dates of Fridays. Errors on entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I create a form using a column of short dates, the date entry creates
and error "invalid entry-text where number expected..." when the first
character is entered. The date is being written to a table of short date
format. Why do I get this error?
 
Hi,


Sounds like code added by a developer. Maybe the code is called in the wrong
event, such as after each keystroke rather than while leaving the control.
If my assumption is right, a possible solution is to move the code to a more
appropriate event.


Hoping it may help,
Vanderghast, Access MVP
 
Hi,


I created a new table, two fields (f1, Text, and f2, Date/Time with a
Short date format), saved it.

I crated an Autoform (from the main toolbar) on that table2.

I open the form, and in the field for f2, I can type QWERTY and no error
message occur, as long as I stay in that control. Only when I move the
cursor to the other control do I get an error (about an invalid entry).

Is it not what you can get for such a new form? If so, what makes it
different than the form where you will get an error as soon as you type,
say, the letter Q, in the short date control?



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top