473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Access UI weirdness -- text selection permanently on

prn
254 Expert 100+
Hi folks,

Sometime in the last few days, I must have accidentally done something that changed some kind of switch in Access, but I can't seem to find what it was.
This is Access 2003 under XP, BTW.

Currently, when I'm editing any kind of textual material within Access, e.g. a SQL statement or something in the Properties for a GUI element, I find that whenever I move the text cursor within that text, it selects (inverts) the text between the old position and the new. For example, if I want to change the name of a textbox from, say, tbxOldName to tbxNewName, I would expect to click my mouse between the "x" and the "O" and edit from there, but when I do that, all the text of "OldName" turns into reverse video and is selected so when I type the "N" for "NewName" everything following the "tbx" disappears. Any click within text selects (generally from the clicked point to the end of the text). This wouldn't be so bad for something this simple, but it does get to be a drag if I'm trying to edit a relatively more complex SELECT statement for, e.g. a row source or the like. The same thing happens when editing a SQL statement in the query designer in SQL view. I do find an interesting and possibly illuminating quirk there, though. If Access positions the cursor somewhere other than at the end of the statement (e.g., at a syntax error ;) ) then no text is "selected" but the text cursor is somewhere in the middle of the SQL statement. If, however, I move the cursor, either with the arrow keys or by clicking with the mouse, then all the text between the location where Access positioned it and the new location gets selected.

Whatever the problem is, it also means that when I try to change the tab order in a form and click on a control in the tab-order list, all of the controls above the one I click on are selected. Furthermore, when I try to drag the selected control(s), they don't move in the tab-order dialog, the only effect is to select the controls that I try to drag them over.

This is definitely an Access problem. All other applications continue to behave normally.

I have looked at Tools>Options and at the menu structure in general and I can't seem to locate an option that might have been changed, but I suppose I could have missed something. So far, I've been able to work around this strange behavior, but copying any complex text into Notepad, editing it there and pasting it back into Access is not really right.

Has anyone seen anything like this before? Has anyone fixed anything like this before? It's weird!

Any clues gratefully accepted.

Thanks,
Paul
May 21 '07 #1
7 2590
dima69
181 Expert 100+
Hi folks,

Sometime in the last few days, I must have accidentally done something that changed some kind of switch in Access, but I can't seem to find what it was.
This is Access 2003 under XP, BTW.

Currently, when I'm editing any kind of textual material within Access, e.g. a SQL statement or something in the Properties for a GUI element, I find that whenever I move the text cursor within that text, it selects (inverts) the text between the old position and the new. For example, if I want to change the name of a textbox from, say, tbxOldName to tbxNewName, I would expect to click my mouse between the "x" and the "O" and edit from there, but when I do that, all the text of "OldName" turns into reverse video and is selected so when I type the "N" for "NewName" everything following the "tbx" disappears. Any click within text selects (generally from the clicked point to the end of the text). This wouldn't be so bad for something this simple, but it does get to be a drag if I'm trying to edit a relatively more complex SELECT statement for, e.g. a row source or the like. The same thing happens when editing a SQL statement in the query designer in SQL view. I do find an interesting and possibly illuminating quirk there, though. If Access positions the cursor somewhere other than at the end of the statement (e.g., at a syntax error ;) ) then no text is "selected" but the text cursor is somewhere in the middle of the SQL statement. If, however, I move the cursor, either with the arrow keys or by clicking with the mouse, then all the text between the location where Access positioned it and the new location gets selected.

Whatever the problem is, it also means that when I try to change the tab order in a form and click on a control in the tab-order list, all of the controls above the one I click on are selected. Furthermore, when I try to drag the selected control(s), they don't move in the tab-order dialog, the only effect is to select the controls that I try to drag them over.

This is definitely an Access problem. All other applications continue to behave normally.

I have looked at Tools>Options and at the menu structure in general and I can't seem to locate an option that might have been changed, but I suppose I could have missed something. So far, I've been able to work around this strange behavior, but copying any complex text into Notepad, editing it there and pasting it back into Access is not really right.

Has anyone seen anything like this before? Has anyone fixed anything like this before? It's weird!

Any clues gratefully accepted.

Thanks,
Paul
Well, I don't know why Access acts that weird way you describe here. Maybe F2 key that changes selection type can assist.
May 21 '07 #2
prn
254 Expert 100+
Thanks, dima69. That wasn't it, but I'm prepared to try almost anything.

Anybody have any other ideas?

Thanks,
Paul
May 21 '07 #3
Denburt
1,356 Expert 1GB
I can confirm this but although I am still trying to pin it down since it seems to come and go. The only tie I have found so far is maybe a sticky keys issue, but I have not found a way to make this change it's behavior other than a reboot. It usually happens to me when I have way to many things open and I am deep in thought about something.

I would test it out right now but I have so much that needs to get done I will try and get back here if I manage to replicate it.
May 21 '07 #4
prn
254 Expert 100+
Well, doggone! I should have taken Denburt's advice even before he gave it! ;)

Of course, I always have too many windows open and all the other usual problems, but a reboot is always the first thing any Microsoft user ought to try. Good call, Denburt!

I still have no idea what happened or whether there is any deeper knowledge to be gained here, but a reboot seems to have cleared it up for now.

Thanks!
Paul
May 22 '07 #5
missinglinq
3,532 Expert 2GB
Sad to say, Windows systems multi-task much better than human brains!
May 22 '07 #6
Denburt
1,356 Expert 1GB
Sad to say, Windows systems multi-task much better than human brains!
I so agree... I still think this issue revolves around those dmn sticky keys but they never do what i want, when I want, can't seem to figure them out but they sure love to screw with me..

Glad your rollin let us know if theres anything else ya need.
May 22 '07 #7
I don't know what causes this problem, but I found sort of a solution. When such thing happens, I go in query design, closing the "Sow Table" dialogue and put some false params in the criteria line, for example "and test()". I move the cursor to another field and error dialogue appears saying "the expression you entered contains invalid syntax". I press OK, and that does it for me, I can normally position my cursor anywhere without selecting anything. Hope this helps.
Feb 17 '12 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Ecohouse | last post by:
I have a computer with XP on it. I loaded Office 97 first because I needed Access 97 for some work. I then loaded Office 2000. Everything seemed to be running fine. But I have come across a few...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
1
by: Bill Stock | last post by:
I trying to create an Excel workbook from Access and then do some formatting of the workbook. I did quite a bit of this with Access 97 a few years back, but I haven't done much with A2K. So I...
6
by: Bob Alston | last post by:
I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the Access report writer capabilities. As far as...
5
by: David Thielen | last post by:
Hi; I am creating png files in my ASP .NET app. When I am running under Windows 2003/IIS 6, the file is not given the security permissions it should have. It does not have any permission for...
4
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is...
1
by: kirkus84 | last post by:
I am currently trying to do a multiple record mail merge through a query via a command button on a form. The query basically displays customers who have said yes to privacy. The user inputs a date...
2
by: Newbie23 | last post by:
Hi All (yet ANOTHER question) The reason for the merge is to create a Quote letter for the selected customer. It's working fine except for the contact address not showing. I have re-written the...
3
by: brat33 | last post by:
I am trying to use a command button to automate a process for creating mailing labels from a query in Access 2007, going into word 2007. Current code looks like the following: 'Start MS Word Dim...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.