Need help with Microsoft access!?

Question

the database I am currently working in is contacts, when i attempt to enter a note under the notes section I get the following error...The value you enter is not valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the fieldsize setting permits...... I was merly trying to put in a note and I keep getting this same error, it also does not matter what contact I am under I will get this error....someone please help!!!

ok I changed it from text to memo, can someone elaborate on the field "allow zero lenthg" does this need to be set to yes or no

....ok so now the same note is showing up over and over in this field, I must be doing something wrong :( any one up for a an emial intervention and save this poor girl?

Answer 1

1) Open the TABLE in DESIGN VIEW
2) Check the Data Type of the field you are trying to enter the memo into. It should be either "Text" or "Memo".

A TEXT type field can hold up to 255 characters. A Memo type field can hold up to 64 K.

Answer 2

Check the datatype of the field you're trying to input data into. Make sure that the datatype is not numeric, meaning a type that takes numbers only.

It sounds like the datatype is set to a numeric one.

Answer 3

'Allow zero length' means accepting that record with nothing in the zero length field.

So unless you are positive you will enter a note in this field for every record as created, allow zero length should be 'YES'

Answer 4

It is wise to set the format of the field as string......data type
since it is easier to compare and update values which does not arise any problems.

but it must be noted that the length of the field must be large enough for string you are to store.