Access changes my characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My field uses a combo box to select entries from a list. The first column and bound column is a number with a width of 0cm, the second column is text and contains listings of towns and cities Eg. Perth (C), Busselton (T). This is the column that is displayed. When I select and entry from the list that is a city eg Perth (C) Access will change the (C) characters to the copyright symbol ©, It then does not accept my selection because it is not a record in the list. How and can I turn off this auto formatting

Cheers
 
This is the spelling autocorrect feature in office.
You can turn it off for any control in Access.
In most datbases, it should be off for most controls, except notes/comments
type fields.

Open the form in design view.
Right-click your combo, and choose Properties.
On the Other tab of the Properties box, set AllowAutoCorrect to No.

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

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

Trevor said:
My field uses a combo box to select entries from a list. The first column
Click to expand...
and bound column is a number with a width of 0cm, the second column is text
and contains listings of towns and cities Eg. Perth (C), Busselton (T).
This is the column that is displayed. When I select and entry from the list
that is a city eg Perth (C) Access will change the (C) characters to the
copyright symbol ©, It then does not accept my selection because it is not a
record in the list. How and can I turn off this auto formatting?
 
Trevor said:
My field uses a combo box to select entries from a list. The first column
Click to expand...
and bound column is a number with a width of 0cm, the second column is text
and contains listings of towns and cities Eg. Perth (C), Busselton (T).
This is the column that is displayed. When I select and entry from the list
that is a city eg Perth (C) Access will change the (C) characters to the
copyright symbol ©, It then does not accept my selection because it is not a
record in the list. How and can I turn off this auto formatting?
Cheers.
Click to expand...

I can't get this error to happen in Access 97.
However, here are some suggestions:

1) Set 'limit to list' for the combo box.

2) Go into Tools | Autocorrect and delete the entry for (C).

David
 
David said:
2) Go into Tools | Autocorrect and delete the entry for (C).
Click to expand...

That will affect all Office applications, not just Access. May not be what
you want. You're better off setting the form control's autocorrect property
to no.
 
Back
Top