Field level size appears to change

[Earl C Phillips]

I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do not, so their field is left blank. Lately when a new entry is tried in this field, only the first three characters are accepted, blocking character four through ten from being entered. It acts as if the text length for this text box has been changed to three characters, but it is still the correct length in the Properties box.

If anyone has encountered something like this, please respond with your fix for this problem. The system keeps track of clients who have attended a nutrition education class and the form involved is the location the class was taught.:banghead:

 

[GinaWhipp]

Never heard of this... so, let's start with something basic, run Compact & Repair on the database, both parts if split.

 

[Earl C Phillips]

I have compressed and repaired both the program and the data file separately. This does not cure the problem. Thanks for the try.

 

[GinaWhipp]

Is there any code on the After_Update of the Control or maybe in the On_Open event of the Form?

 

[Gasman]

I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do not, so their field is left blank. Lately when a new entry is tried in this field, only the first three characters are accepted, blocking character four through ten from being entered. It acts as if the text length for this text box has been changed to three characters, but it is still the correct length in the Properties box.

If anyone has encountered something like this, please respond with your fix for this problem. The system keeps track of clients who have attended a nutrition education class and the form involved is the location the class was taught.:banghead:

Has the field in the table been changed?

 

[Earl C Phillips]

The solution: Delete the offending master record and create a new one with the correct information. It works. Thanks for all the suggestions.