How do I preserve three dots?

  • Thread starter Thread starter Brian Kastel
  • Start date Start date
B

Brian Kastel

When I attempt to enter three consecutive dots into a field, Microsoft
Access insists that I REALLY wanted to enter an ellipsis character
(Alt+0133) and proceeds to change them to it. Access is so insistent that
this is my REAL intention that it has thwarted every attempt I have made to
work around this "feature." I am assuming that there is a simple option
switch hidden deep within the labyrinthine menus that will turn off this
feature, but I have been so far unable to unearth it. I tried the simple
(entering four dots, moving to the next field, then going back to delete one
of the middle dots) and the sublime (creating an update query that truncated
the last dot from the record field, in the vain hope that the feature logic
was coded into the datasheet entry portion of the application). Nothing has
worked.

Has anyone else defeated this annoyance?
 
You may be able to hit Ctrl+Z to undo as soon as the AutoCorrect changes the
entry.

Text boxes and combos have an AllowAutoCorrect property (Other tab of
Properties box). In most databases, this should be set to No for all combos
and most text boxes (except for Notes/Comments fields).

If you want the entry removed so none of the Office applications, do this,
delete the entry under Tools | AutoCorrect.

For information on how to create forms where the text boxes and combos
default to No for AutoCorrect, see:
Setting up Default Forms and Reports
at:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Hi Brian,

In Access 2000, click on Tools > Autocorrect...
In Access 2002, click on Tools > Autocorrect Options...

Look for three consecutive dots in the Replace column. You can either delete that record, or
deselect the option that reads "Replace text as you type".

Tom

PS. Very creative munging of your e-mail address!
____________________________________


When I attempt to enter three consecutive dots into a field, Microsoft
Access insists that I REALLY wanted to enter an ellipsis character
(Alt+0133) and proceeds to change them to it. Access is so insistent that
this is my REAL intention that it has thwarted every attempt I have made to
work around this "feature." I am assuming that there is a simple option
switch hidden deep within the labyrinthine menus that will turn off this
feature, but I have been so far unable to unearth it. I tried the simple
(entering four dots, moving to the next field, then going back to delete one
of the middle dots) and the sublime (creating an update query that truncated
the last dot from the record field, in the vain hope that the feature logic
was coded into the datasheet entry portion of the application). Nothing has
worked.

Has anyone else defeated this annoyance?
 
Brian Kastel said:
When I attempt to enter three consecutive dots into a field, Microsoft
Access insists that I REALLY wanted to enter an ellipsis character
(Alt+0133) and proceeds to change them to it. Access is so insistent
that this is my REAL intention that it has thwarted every attempt I
have made to work around this "feature." I am assuming that there is
a simple option switch hidden deep within the labyrinthine menus that
will turn off this feature, but I have been so far unable to unearth
it. I tried the simple (entering four dots, moving to the next
field, then going back to delete one of the middle dots) and the
sublime (creating an update query that truncated the last dot from
the record field, in the vain hope that the feature logic was coded
into the datasheet entry portion of the application). Nothing has
worked.

Has anyone else defeated this annoyance?
Click to expand...

Click Tools -> AutoCorrect Options..., locate the entry in the list for
this replacement, and delete it.
 
Thanks!

Allen Browne said:
You may be able to hit Ctrl+Z to undo as soon as the AutoCorrect changes the
entry.

Text boxes and combos have an AllowAutoCorrect property (Other tab of
Properties box). In most databases, this should be set to No for all combos
and most text boxes (except for Notes/Comments fields).

If you want the entry removed so none of the Office applications, do this,
delete the entry under Tools | AutoCorrect.

For information on how to create forms where the text boxes and combos
default to No for AutoCorrect, see:
Setting up Default Forms and Reports
at:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
Click to expand...
 
I knew Word had that, but I didn't realize those settings were
cross-application.

Thanks to all who replied.
 
Back
Top