date/time fieldsize error

L

loreeslp

Hi there, I keep getting a fieldsize error when trying to put a date in the
table. I am using Access 2003. I don't see where I can set a fieldsize for
the date/time. Thanks
 
L

Lord Kelvan

regardless it sounds like the value youa re entering is not a valid
date please check what you are entering

Regards
Kelvan
 
L

loreeslp

02/29/2009 - this is the exact date I am trying to enter. I have done it
about 50 times today after trying different settings, etc. (I am going to
dream about it tonight). lol Wait.....I think I just figured it out. Doh'
it is because it is not leap year next year. Ohhhh the brain cells I have
wasted today. Thanks anyway.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change text FieldSize property in DAO 6
Set FieldSize on new field in make table query 2
Combo Box Errors 9
Displaying digits after the decimal point 5
access, error message 1
Autofill Date in Word 15.33 for Mac 0
Display weeks from a Milestone 0
Function in query 0

Top