turn off auto correct

[Paul M]

Hi
I wish to turn off auto correct for spelling for table data. I am using
access pro 2003
Thankyou
Paul M

 

[Allen Browne]

You turn off the spelling auto-correction for any text box or combo on your
*form* by opening the form in design view, and setting the property.

If you want to do this programmatically for all text boxes and combos on all
forms, the code below shows how. It assumes no forms are open at the start.

Function FixForms()
Dim accobj As AccessObject
Dim frm As Form
Dim ctl As Control
Dim strDoc As String

For Each accobj In CurrentProject.AllForms
strDoc = accobj.Name
DoCmd.OpenForm strDoc, acDesign, WindowMode:=acHidden
For Each ctl In Forms(strDoc)
Select Case ctl.ControlType
Case acTextBox, acComboBox
If ctl.AllowAutoCorrect Then
ctl.AllowAutoCorrect = False
Debug.Print strDoc & "." & ctl.Name
End If
End Select
Next
DoCmd.Close acForm, strDoc, acSaveYes
Next
End Function

 

[Paul M]

Thanks Allen
when you open Access and then a table when I add cafe to one of the fields
it changes it to the french spelling with the accent over the e this is a
problem because when this database is uploaded to my site the form input
will write cafe without the accent and the search returns nothing
It is the spell check I wish to turn off when you add records manaully not
through a form
Thanks
Paul M

 

[Allen Browne]

Paul, you can turn off the spelling auto-correct completely, but I do not
recommend you do that.

In Access, tables are just to hold the data. They are not the interface, and
don't have the power to manage things like which fields have spelling
correction, or what events fire when you enter something. You need to create
a form for entering your data if you want to manage the interface.

You can create a form that looks like a table if you wish. Use Datasheet
view.

 

[Paul M]

Hi Allen
I am using access only for holding data and I am editing the table data
direct All of the accessing this data is done by the web and asp/vb. Its
just annoying that there is a word "cafe" in the description field that
cannot be searched because access is correcting its spelling
please take a look
http://www.paulcmilner.co.uk/art/defaultsearch.asp?search=cafe

Thanks
Paul M

 

[Allen Browne]

Paul, I can understand your annoyance, but I can't help you if you type
directly into the table.

 

[Paul M]

Thanks Allen
I have created a form to input the data wheredo I insert the function to
stop auto correct in a field called image_desc
Thanks, access is new to me I am used to online databases

Paul M

 

[Paul M]

Hi Allen I have found a compromise when I change the spelling it asks me if
I want to revert back to my previous spelling.
Another question though. At the bottom of the form there are some move to
the next record controls. How do I make so that I can enter a number then go
to that record it not in the auto number field but in another field called "
image_number"
Thanks
Paul M

 

[Allen Browne]

To set the Allow AutoCorrect property of controls in your form:

1. Open the form in design view.

2. Select the text box where you want to turn the spelling correction off
(or use Shift+Click to select several at once.)

3. Open the Properties box. On the Other tab of that box, choose No beside:
Allow AutoCorrect

Note that if you want the form to look like a table, just set the Default
View property of the *form* to:
Datasheet

If you want to progrmmatically find a record by typing the ID number, place
the form in Continuous (or Form) View, and add an unbound text box to the
Form Header section. Use the AfterUpdate event procedure of this text box to
find the record in the form's Clone set.

The code do do that looks like this:
http://allenbrowne.com/ser-03.html
That example talks about a combo, but you can use exactly the same code for
a text box if you wish.

 

[Paul M]

Thanks Allen
Paul M

To set the Allow AutoCorrect property of controls in your form:

1. Open the form in design view.

2. Select the text box where you want to turn the spelling correction off
(or use Shift+Click to select several at once.)

3. Open the Properties box. On the Other tab of that box, choose No
beside:
Allow AutoCorrect

Note that if you want the form to look like a table, just set the Default
View property of the *form* to:
Datasheet

If you want to progrmmatically find a record by typing the ID number,
place the form in Continuous (or Form) View, and add an unbound text box
to the Form Header section. Use the AfterUpdate event procedure of this
text box to find the record in the form's Clone set.

The code do do that looks like this:
http://allenbrowne.com/ser-03.html
That example talks about a combo, but you can use exactly the same code
for a text box if you wish.