469,603 Members | 2,076 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

A97 - I cannot prevent Access from changing (c) to a copyright symbol when typing into a memo field

MLH
I'm trying to type

(a), (b) or (c)

into an Access 97 memo field.
Access keeps turning it into a copyright symbol ( © )
How can I override that? I don't want a copyright symbol.
Nov 13 '05 #1
3 2926
Change it in AutoCorrect or turn AutoCorrect off.

Nov 13 '05 #2
MLH
Thx pietlinden.

I always seem to forget about that.

Nov 13 '05 #3
MLH <CR**@NorthState.net> wrote in
news:pn********************************@4ax.com:
I always seem to forget about that.


Well, it was bloody stupid of Microsoft to enable AutoCorrect by
default in all fields in a frigging *DATABASE* application.

Data validation is everything in a data base, and having a component
that is contollable from many different applications other than
Access and that the developer has no control over means that there's
a validation step going on that a developer has no control over.

To that end, I use the code at the end of my signature to turn off
AutoCorrect in all fields in all forms in an MDB.

This is an example of bloody idiocy on Microsoft's part, where
fidelity to the Office product line's normal featureset is in
contradiction to the basic purpose of the Access.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Public Sub GetRidOfAutoCorrect()
' Turns off AutoCorrect for all text boxes and
' combo boxes on all forms in an MDB
Dim cnt As Container
Dim doc As Document
Dim strForm As String
Dim frm As Form
Dim ctl As Control

For Each cnt In CurrentDb.Containers
If cnt.name = "Forms" Then
For Each doc In cnt.Documents
strForm = doc.name
DoCmd.OpenForm strForm, acDesign
For Each ctl In Forms(strForm).Controls
If ctl.ControlType = acTextBox _
Or ctl.ControlType = acComboBox Then
ctl.AllowAutoCorrect = False
End If
Next ctl
DoCmd.Close acForm, strForm, acSaveYes
Next doc
End If
Next cnt

Set cnt = Nothing
Set doc = Nothing
Set ctl = Nothing
End Sub
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.