Date field problem

[paulquinlan100]

Hi

I have a date field which when i enter the date in some places, works
fine, however, when trying to enter dates on certain rows i get the
message:

"The value you entered isn't valid for this field. For example you
have entered text in a numeric field" etc.

It seems to be fairly random which rows are ok and which arent. The
data was originally imported from an excel spreadsheet where those
containing dates had the custom format dd/mm/yyyy and the empty fields
had a general format. However, i dont think this can be the problem as
it occurs totally randomly.

Any ideas?
Thanks for any suggestions
Paul

[Allen Browne]

The error message should only occur in invalid dates, such as 29/2/2007.

You might like to simplify things by making sure you have the right format
set in the Regional Options in the Windows Control Panel, and then removing
the custom format from your text boxes and table fields.

More info about avoiding problems with dates in a d/m/y country:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pa************@hotmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>
I have a date field which when i enter the date in some places, works
fine, however, when trying to enter dates on certain rows i get the
message:

"The value you entered isn't valid for this field. For example you
have entered text in a numeric field" etc.

It seems to be fairly random which rows are ok and which arent. The
data was originally imported from an excel spreadsheet where those
containing dates had the custom format dd/mm/yyyy and the empty fields
had a general format. However, i dont think this can be the problem as
it occurs totally randomly.

Any ideas?
Thanks for any suggestions
Paul