ADP text box issue: Backspace deletes ALL text.

[Danny J. Lesandrini]

OK, I have never noticed this before, but I'm getting a consistent issue
with text boxes on my Access form in an ADP with data in SQL Server.

1) Click in a text box with text
2) Cursor is flashing at end of text
3) Press Backspace key
4) ALL text is deleted
5) Press ESC key to undo delete
6) All text is now selected
7) Click again at end of text
8) Press Backspace key
9) Text deletes one character at a time

There is no code behind the text box or elsewhere that forces its behavior.
Same behavior happens when I add a new text box with a new name that
points to the same field. (It happens for all fields too!)

So, is it a form property? A SQL Server setting/issue? Anyone else seen this?
--
Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast

[Lyle Fairfield]

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in
news:Ic********************@comcast.com:

OK, I have never noticed this before, but I'm getting a consistent issue
with text boxes on my Access form in an ADP with data in SQL Server.

1) Click in a text box with text
2) Cursor is flashing at end of text
3) Press Backspace key
4) ALL text is deleted
5) Press ESC key to undo delete
6) All text is now selected
7) Click again at end of text
8) Press Backspace key
9) Text deletes one character at a time

There is no code behind the text box or elsewhere that forces its
behavior. Same behavior happens when I add a new text box with a new
name that points to the same field. (It happens for all fields too!)

So, is it a form property? A SQL Server setting/issue? Anyone else
seen this?

Hi Danny

I checked on a couple of forms (ADP XP, Access 2000 file format, MS-SQL
Server 2000) but I cannot duplicate the behaviour you describe.

If it occurs in just one form then perhaps it's just buggy and a
SaveAsText, LoadFromText might cure it?

I find with ADPs that I have to do this occasionally to clear up some
problem which seems to have no rhyme nor reason.

--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.

[Danny J. Lesandrini]

Well, I went back to a back up and imported the form, but it didn't help.
Then I remembered that it all started after I created a new ADP and imported
all the objects. Anything brought into this new file automatically experiences
the new issue. I haven't had time to look yet, but my guess is that it's in the
properties of the ADP and that's where I'll look next.

Couldn't find anything in Google about this and if I figure it out, I'll post
the answer here.

Thanks Lyle.
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/
"Lyle Fairfield" <Lo******@FFDBA.Com> wrote ...

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote:

OK, I have never noticed this before, but I'm getting a consistent issue
with text boxes on my Access form in an ADP with data in SQL Server.

1) Click in a text box with text
2) Cursor is flashing at end of text
3) Press Backspace key
4) ALL text is deleted
5) Press ESC key to undo delete
6) All text is now selected
7) Click again at end of text
8) Press Backspace key
9) Text deletes one character at a time

There is no code behind the text box or elsewhere that forces its
behavior. Same behavior happens when I add a new text box with a new
name that points to the same field. (It happens for all fields too!)

So, is it a form property? A SQL Server setting/issue? Anyone else
seen this?

Hi Danny

I checked on a couple of forms (ADP XP, Access 2000 file format, MS-SQL
Server 2000) but I cannot duplicate the behaviour you describe.

If it occurs in just one form then perhaps it's just buggy and a
SaveAsText, LoadFromText might cure it?

I find with ADPs that I have to do this occasionally to clear up some
problem which seems to have no rhyme nor reason.

--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.