Access Tab character bug

[Galaxiom]

Paste some text that includes a Tab character into a text field (or bound control on a form).

Now try to edit the text.

Guaranteed to do in the mind of an unsuspecting victim.

(Access 2010, mdb file, Windows 7 Pro)

 

[AccessJunkie]

Hi,

I'm trying to repro the issue you are seeing on my own test machines. I've tried your steps on Access 2010 with an MDB file on Windows 7 and I'm still able to edit the text in this scenario.

Can you provide some more detail on what issues you are encountering here?

If there is a bug here, I'd like to make sure I can repro it before entering it into our system.

Thanks,

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
Senior SDET - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2013 Inside Out
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010/2013 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[spikepl]

A2010 (original file A2007 - so nop MDB), Win7:

abc(tab)efg where (tab) is the tab character, in Notepad.

If copied and pasted into a rich-text field, no issue.

If copied into a normal text field, it looks like this (cursor one space to the right off letter g):

then, if I press BACKSPACE once, then it looks like this:

and the cursor, not shown here, is one space after f. The cursor remains with one space between it and the remainder of the text, if I keep pressing BACKSPACE, until I delete the original tab character, and now there is no more space between cursor and text.

 

[Galaxiom]

Spike shows what happens for me but I had the tab at the beginning of the text.

Also try backspacing in the middle of the text, then move to another record.

I discovered this bug after pasting text from a bulleted list in Word then trying to clean it up.

 

[AccessJunkie]

Hi everyone,

Thanks for the additional information on the issues you are facing here and the expanded repro steps.

With the additional information I can also repro the issue on my test machines now. In the backspace scenario that is indeed very odd. It's almost like a magic eraser - removes one letter from the end even though the cursor is not in that position. Very weird indeed.

I'll log this issue into our system here in case we don't already have it logged.
Thanks for passing this along.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
Senior SDET - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2013 Inside Out
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010/2013 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[Galaxiom]

Ah Jerff a Microsoft insider.

Can you suggest they have a look at this bug too.
http://www.access-programmers.co.uk/forums/showthread.php?t=256901

 

[Galaxiom]

And the mistake in the help for Nz function as discussed in this thread.
http://www.access-programmers.co.uk/forums/showthread.php?t=248477

And this obvious mistake regarding the Locked property:
http://office.microsoft.com/en-au/access-help/HV080750900.aspx