Dan Waters
dwaters at usinternet.com
Fri Nov 18 10:58:24 CST 2005
Yes - I didn't think of this but my main screen does have a 1 minute timer event. The code auto-spacing seemed to happen at random times, but perhaps every minute might be about right. Try a test with and without the timer to see what happens! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Friday, November 18, 2005 9:26 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Syntax Corrections Do you get it too then Dan? I don't mean when you finish the line, which I agree has always happened, I'm talking about on a line which is half-completed and you pause in your typing (and sometimes I barely even pause), watch the screen and bam there it goes. As I've just said to Susan it's actually only happening in a specific mdb. I just created a new mdb, a new module, typed my test str=str & " and in the new mdb it just sat there politely, as I want, waiting for me to finish. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Syntax Corrections Date: 18/11/05 16:18 Andy, I can't remember when the space weren't added automatically. Don't know how to turn it off. Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Friday, November 18, 2005 8:45 AM To: Access Developers discussion and problem solving Subject: [AccessD] Syntax Corrections Ok I've put up with it for a while but this is driving me nuts now. Access 97. This has started fairly recently and I'm not aware of having changed any setting to cause it. What it is is that as I type code Access will, on occasions, 'correct' it as I type. Let me give you an example. I type: strA=strA & " I haven't finished the line but sometimes (and always if I hesitate long enough) Access will automagically add spaces either side of the = for me and a second " so that what I now have is strA = strA & "" Now that's ok except that while 3 characters have thus been added to the line the cursor hasn't moved. Instead, therefore, of being at the end of the line it's now 3 spaces before the end (immediately after the & in my example). If I'm not looking at the screen and keep typing my text then when I do eventually look up, or just hit enter at what I think is my line end, the statement is shot to pieces. I've tried unchecking various Options (eg Auto Syntax Check) but I can't seem to stop it. I swear that what used to happen was that this tidying up occurred only when I hit Enter at the end of a line. Doing it while I'm still typing the line is doing my head in. Does anyone know how I switch this behaviour off? -- Andy Lacey http://www.minstersystems.co.uk ________________________________________________ Message sent using UebiMiau 2.7.2 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com