Editing Table Infomation in a Form

[schoultzy]

Hello Everyone,

I am using Access 2003. I have a form in a database which is used to
edit cells in a table. There are 4 textboxes in the form and each one
is tied to a table cell. When the form is opened, the current
information in each of those cells is displayed. My problem comes when
I want to edit this information.

The table cells are set to a maximum of 250 characters. If the current
entry in a cell has 100 characters, I am not able to change the entry
to on that is larger. For example, if the current entry in the cell is
"hello", which is 5 characters long, and I want to change it to "hello
and welcome" which is 17 characters long I am unable to do this. After
I delete the entry in the form textbox, I start typing the new entry.
When I get to about the 5th or 6th character in the new entry, I am
unable to type any more characters. Every time I attempt to type
another character I get the standard "you can't do that stupid" sound
from Access. If, however, I click into another textbox in the form and
then click back into the textbox that I want to edit and attempt to
type again, I am able to make the change without incident.

I have been using this process of delete, type until I can't type
anymore, click into another textbox in the form, click back into the
original textbox and continue typing the remainder of the new entry and
it works. This is, however, very annoying and I would think that there
should be an easier way. I hope that someone out there has had this
problem before so that I don't feel like an idiot. Thanks for your
help in advance.

 

[John Vinson]

The table cells are set to a maximum of 250 characters. If the current
entry in a cell has 100 characters, I am not able to change the entry
to on that is larger.

That's very odd, and it's certainly *NOT* typical Access behavior!
Open the Form in design view and view this textbox's Properties. Is
there anything in the Events tab - in particular in the Change event?
If so, please post the code. You may also want to check the Form's
KeyPreview and OnKey properties.

Another possibility is that the database (this form particularly) is
corrupt. You might try Tools... Database utilities... Compact and
Repair to see if that changes anything.

John W. Vinson[MVP]

 

[schoultzy]

Hi John,

Thanks for replying. There is no associated with the Change Event,
however, there is some code for the On Open and After Update Events.
That code follows:

Private Sub counselor_responsible_AfterUpdate()
counselor_id_num = counselor_responsible.Column(2)
counselor_title = counselor_responsible.Column(1)
End Sub

Private Sub Form_Open(Cancel As Integer)
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Select [Expr1000] From [Select System
User]")
rs.MoveFirst
User = rs!Expr1000
End Sub

As for the properties you suggested I check, the OnKey properties are
not set and the KeyPreview property is set to NO. Thanks again for
your help.

Matt

 

[John Vinson]

Thanks for replying. There is no associated with the Change Event,
however, there is some code for the On Open and After Update Events.
That code follows:

Nothing there is obviously wrong.

I wonder if the Form itself is corrupt. Try creating a new Form; copy
and paste the controls from this one onto it, and set its Properties
to match. Compact the database when you're done and see if the new
form works better.

John W. Vinson[MVP]