Error 3163

[Elcid7236]

The following is a TEXT BOX with these properties.

Name……………………Date
Control Source………Date
Format…………………Short Date (12/02/2007)
Input Mask…………...99/99/0000;0;_

This text box is on a form linked to Tbl_Advance_Mission. All records are
available to select using the scroll (VCR BUTTONS) buttons at the bottom of
the form.

When I click the “New Record†vcr button and go to the “Date†field and
begin to enter data, I receive the following error message:


“The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.â€

If I click Help, I receive the following message:

“The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data. (Error 3163)â€


I then click OK and the message repeats. I click OK again and the message
goes away and I can enter data. The number I tried to enter before now shows
up and the cursor is awaiting the next digit in the date.

I have never had this problem in any other Access database I created.

Help!

 

[Jeanette Cunningham]

Elcid7236
is the field for the date a date time field?
Maybe the form has become corrupted.
Create a new form (just a basic form for testing)
If this new form works OK, only then polish it up with other necessary
controls and code etc.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Elcid7236]

Yes,
it is a Date/Time Field.
I built a new form and it worked....Hooray!
I will do dome more testing, but it worked....did I say Hooray?
HOORAY!...

Thank you sooooooooo much.