[AccessD] Syntax Corrections

Andy Lacey andy at minstersystems.co.uk
Fri Nov 18 09:20:08 CST 2005


Hi Jim
Unless I'm going blind (perfectly possible) A97 doesn't have an AutoCorrect
in Tools Options. It has all kinds of other things, like Auto Syntax Check,
which I've tried unchecking, but if it's a combination of these then I
haven't hit on the right combination yet.

--
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:12



Turn off Auto Correct in tools/options.

Jim.

-----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: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




More information about the AccessD mailing list