How convince Access to stop "fixing" my text?

I have a Memo field in an Access 2000 database that contains information
that is not just plain old text - it's information my program needs, and it
needs to be in a specific format.

The problem is, Access keeps trying to "help" me by capitalizing it whenever
I enter the single letter 'i', and has other issues that I think are due to
some kind of "text fixup" mode it thinks it should be in.

I turned off "Perform Name AutoCorrect" in the Options dialog, but what else
do I need to do, to tell Access to stop "helping" me, and just let me type
into the Memo field what I want to?

Thanks,
Chris

Re: How convince Access to stop "fixing" my text?

Chris Shearer Cooper wrote:
> I have a Memo field in an Access 2000 database that contains
> information that is not just plain old text - it's information my
> program needs, and it needs to be in a specific format.
>
> The problem is, Access keeps trying to "help" me by capitalizing it
> whenever I enter the single letter 'i', and has other issues that I
> think are due to some kind of "text fixup" mode it thinks it should
> be in.
> I turned off "Perform Name AutoCorrect" in the Options dialog, but
> what else do I need to do, to tell Access to stop "helping" me, and
> just let me type into the Memo field what I want to?
>
> Thanks,
> Chris

Turn AllowAutoCorrect off in the properties of the TextBox control.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Re: How convince Access to stop "fixing" my text?

On Tue, 29 Jan 2008 17:01:10 -0700, Chris Shearer Cooper wrote:

> I have a Memo field in an Access 2000 database that contains information
> that is not just plain old text - it's information my program needs, and it
> needs to be in a specific format.
>
> The problem is, Access keeps trying to "help" me by capitalizing it whenever
> I enter the single letter 'i', and has other issues that I think are due to
> some kind of "text fixup" mode it thinks it should be in.
>
> I turned off "Perform Name AutoCorrect" in the Options dialog, but what else
> do I need to do, to tell Access to stop "helping" me, and just let me type
> into the Memo field what I want to?
>
> Thanks,
> Chris

Your problem is not Name AutoCorrect (in Tools + Options General tab),
but AutoCorrectOptions on the Tool menu (they're different).
Either delete the reference to capitalize the letter i in
AutoCorrectOptions (this will effect all Office programs), or set the
AllowAutoCorrect property of the Memo control to No.

Leave Name AutoCorrect unchecked anyway. it causes other problems.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Re: How convince Access to stop "fixing" my text?

The fix is to not use the memo field for application requirements. The
memo field is a bad choice for anything that requires indexing or will
be used in queries against the application. The memo field is desinged
to hold large data -- in theory -- the memo field can hold more data
than an Access mdb can support - Access can hold up to 1 gig of data
(although I have never been able to store that much data in an Access
mdb before it died). A memo field can hold something like 2 gigs of
data.

If you have to query data stored in a memo field then there is something
wrong with the design of your application. I will guess that you are
probably not using referential integrity (table relationships). You
should break up the data in your memo fields and store that data in a
detail table with specific fields designated for specific parts of the
data in your memo fields. The proof is this. If you have to query your
memo fields then there is some structure to the data in your memo field
that you are trying to query. This structure is much more efficiently
and reliably stored in separate fields in a detail data table.

Memo fields are more for storing description type information. You can
query a memo field, but not for routine application operations - not
advisable.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Re: How convince Access to stop "fixing" my text?

Others have pointed you to the correct solution, i.e. the Allow AutoCorrect
property of the text box, not the Name AutoCorrect property of the database.

Here's some information on how to set up your database so new forms
automatically have this property set to No for text boxes and combo boxes:
Default forms, reports and databases
at:
http://allenbrowne.com/ser-43.html

(It deals with lots of other issues too, but this one is particularly
important for combo boxes.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Chris Shearer Cooper" wrote in message
news:13pvfm336l0dq8d@corp.supernews.com...
>I have a Memo field in an Access 2000 database that contains information
>that is not just plain old text - it's information my program needs, and it
>needs to be in a specific format.
>
> The problem is, Access keeps trying to "help" me by capitalizing it
> whenever I enter the single letter 'i', and has other issues that I think
> are due to some kind of "text fixup" mode it thinks it should be in.
>
> I turned off "Perform Name AutoCorrect" in the Options dialog, but what
> else do I need to do, to tell Access to stop "helping" me, and just let me
> type into the Memo field what I want to?
>
> Thanks,
> Chris

Re: How convince Access to stop "fixing" my text?

On Jan 29, 7:38=A0pm, Rich P wrote:
"Access can hold up to 1 gig of data (although I have never been able
to store that much data in an Access mdb before it died)."

Which version are you using? The 1GB limit was raised to 2GB in
Access2K. I've had databases that needed to be compacted daily just
to stay under that limitation.