Text deleting incorrectly in text box

[TJBernard]

I searched Google and this forum, and maybe I did not know the correct phrase to search against, but I did not find anything on this issue.

I have an MS Access 2003 database with a SQL back-end. It works great, quick, multiple users in at the same time with no issues, etc.

But a user has showed me a strange problem I cannot really trap, much less find a cause or a solution. There are some large text boxes on the form, that allow for multiple lines of entry. They will display up to 5 lines of text, and about 100 characters wide (so they are very large).

Randomly (I cannot get it to repeat) the text will delete incorrectly. When you first go to a tab (the form has 7 tabs on it) the text in the large text boxes is highlighted. So the users scroll to the end of the text (which un-highlights the text) then they press the space bar (to start typing again) and randomly all the text will delete and be replaced with the space bar. It is as if the text was never unselected, even though the high lighting is gone, and the text has been unselected by clicking within the text and scrolling to the end of the text.

Has anyone run into this before, and if so, is there anything that can be done to fix the error? I am going to add the Zoom box functionality, with the code...

SendKeys "+{F2}", True

Thank you!

T.J.

 

[missinglinq]

With ACC2003, I have to ask if you've installed the SP3 update! It has so many bugs that nothing would surprise me! The behavior is obviously aberrant; if not the result of a bug (maybe someone else has heard of this) you have to consider corruption, I guess!

As to invoking the ZoomBox, SendKeys are very problematic, and apparently becoming even more so with each ensuing version of Access. You might consider using

DoCmd.RunCommand acCmdZoomBox

instead, which does the same thing. A good method of implementation is in the DoubleClick event.

Private Sub YourTextBox_DblClick()
   DoCmd.RunCommand acCmdZoomBox
End Sub

Good Luck!

 

[TJBernard]

With ACC2003, I have to ask if you've installed the SP3 update! It has so many bugs that nothing would surprise me! The behavior is obviously aberrant; if not the result of a bug (maybe someone else has heard of this) you have to consider corruption, I guess!

As to invoking the ZoomBox, SendKeys are very problematic, and apparently becoming even more so with each ensuing version of Access. You might consider using

DoCmd.RunCommand acCmdZoomBox

instead, which does the same thing. A good method of implementation is in the DoubleClick event.

Private Sub YourTextBox_DblClick()
   DoCmd.RunCommand acCmdZoomBox
End Sub

Good Luck!

Thank you very much for your help. I will have to find out if we have SP3 installed or not here at work.

Thanks!