Software

Ask something
Discussion Locked

Date entry invalid Access database

0 helpful
3 replies

by jeffryg 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Running a simple access xp database, think its a template design included with Office.
When I want to preview a report it prompts for the start & end date. After inputing the start date, try to switch to the end date & an error pops up saying, "the value entered isn't valid for this field". What? haha
Any help with this issue would be such a relief.
Thanks

3 replies

by bob sellman

Just an idea....How are you entering the date, versus how is the date format set up? What I'm specifically thinking of is that dates may be set up for the US type of format (mm/dd/yy or yyyy) and you may be entering using a European format (dd/mm/yy or yyyy) [or vice versa].

Try entering the starting and ending dates using the reverse of whatever format you were using. Otherwise, when you get to a date like 1/14/2002 it is not valid if entered as 14/01/2002.

by jeffryg

Thought that was the issue but I changed the form properties to accept short & long inputed dates.
thanks

This discussion is closed to new replies.