Data Entry changes my data from acn to can - help!

[Guest]

When I enter the data ACN into a text data field, it is automatically changed
to CAN. The field is a key. I have no idea what causes this. Can someone
advise me?

 

[George Hepworth]

Do you have auto-correct enabled?

George

 

[Guest]

It's something I hate! It's autocorrect of spelling just like in Word. Except
databases are often used for technical information and not plain old language.

Open the form in design view. Right click on the text box in question and
bring up Properties. Go to the Other tab and turn off Allow Autocorrect.

AFAIK there is now way to turn it off globally. You must turn Allow
Autocorrect off on each and every text box in every form. BTW: This is not
the same thing as Name Autocorrect. That's another nightmare......

 

[Pieter Wijnen]

Turn off the AutoCorrect (Control property)
(See Code below )

Pieter

Public Sub TurnOffAutoComplete()
Dim Db As DAO.Database
Dim Cont As DAO.Container
Dim Doc As DAO.Document
Dim Frm As Access.Form
Dim Ctl As Access.Control
Dim CCb As Access.ComboBox

Set Db = Access.CurrentDb()
Set Cont = Db.Containers("Forms")

For Each Doc In Cont.Documents
Access.DoCmd.OpenForm Doc.Name, Access.AcFormView.acDesign,
WindowMode:=Access.AcWindowMode.acHidden
Set Frm = Access.Forms(Doc.Name)
For Each Ctl In Frm.Controls
Select Case Ctl.ControlType
Case Access.AcControlType.acComboBox:
Set CCb = Ctl
CCb.AllowAutoCorrect = False
Set CCb = Nothing
End Select
Next 'Ctl
Set Frm = Nothing
Access.DoCmd.Close Access.AcObjectType.acForm, Doc.Name,
Access.AcCloseSave.acSaveYes
Next 'Doc
Set Cont = Nothing
Set Db = Nothing
End Sub

 

[Dirk Goldgar]

In

It's something I hate! It's autocorrect of spelling just like in
Word. Except databases are often used for technical information and
not plain old language.

Open the form in design view. Right click on the text box in question
and bring up Properties. Go to the Other tab and turn off Allow
Autocorrect.

AFAIK there is now way to turn it off globally. You must turn Allow
Autocorrect off on each and every text box in every form. BTW: This
is not the same thing as Name Autocorrect. That's another
nightmare......

In Access 2002, at least, you can click Tools -> AutoCorrect Options...
and change the options in that dialog, or edit the dictionary entries.