Access field saying not in proper format

[fixppheart]

I have a field (date field) that when I try to imput data will tell me that that what is being imputted is not in the correct formate or to large for the field settings. It is in the right formate etc. Is the field size applicable to just that field or overall everything entered in that field in the whole database? It's a decient size data base and I'm wondering if everything in that field is over the size, but then how can that be?

Help!

 

[boblarson]

What exact format is it set to? And what is an example of what you are typing in which gives you that error?

 

[fixppheart]

Date/Time is the formate, I never set the formate for the date, but I tried that an it still did the same thing. The formate mask is ##/##/0000;0;_

I just enter the date, like for example 02292007 for 02/29/2007.

I have multipul fields set up with this same formate for dates and only one column (field) gives me this issue and just started, never had a problem before today.

 

[Rabbie]

I have multipul fields set up with this same formate for dates and only one column (field) gives me this issue and just started, never had a problem before today.

Then I would doublecheck the formatting for just that column because it looks like you may have a typo in the mask for just that field. Try deleting and re-adding it

 

[boblarson]

And it is possible your form is just corrupt. You might try importing everything into a new, blank mdb file and see how it goes. But, I would definitely get rid of the # signs in the input mask as it should actually be zeros there. A # sign in the input mask means optional.