473,326 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How to disable auto-replace feature?

Hi all,

I am a MS Access developer. I develop MS Access application that
would allow my clients to key in their customer information. The
Access application only contains a run-time version of MS Access. My
clients don't have the full version of MS Access. To protect my
codes, I have disabled the Toolbar/menu and Database Windows before
packaging my application using InstallShield.

The problem that I am having is, when my clients enter the names of
their customer, let's say the word Cotten in the last name field. MS
Access automatically replaces the Cotten with Cotton. May I ask if
there is any way I can disable this feature programmatically?

Thanks in advance,
Monte

Apr 9 '07 #1
4 5236
The field in your Form should have a property (under the 'other' tab)
called "AllowAutoCorrect". By default this is set to 'YES', so you
would set it to 'NO'.

Programmatically it would be something like:

Forms("FormName").Controls("ControlName").AllowAut oCorrect = False

Apr 9 '07 #2
On Apr 9, 2:52 pm, kotar...@hotmail.com wrote:
The field in your Form should have a property (under the 'other' tab)
called "AllowAutoCorrect". By default this is set to 'YES', so you
would set it to 'NO'.

Programmatically it would be something like:

Forms("FormName").Controls("ControlName").AllowAut oCorrect = False
Please forgive my ignorance. I am more family with web-related stuff
because I have been a web developer for 9 years. However, when it
comes to VBA, I am just a newbie. May I ask if this AllowAutoCorrect
is available in VBA for Access 2002?

Reason I ask is, I added the following codes,

Private Sub Last_Name_GotFocus()
Me.AllowAutoCorrect = False
End Sub

When I tabbed to the Last Name field, it bombed out saying that
AllowAutoCorrect is not a valid property.

Apr 15 '07 #3
<sw***********@gmail.comwrote
>The field in your Form should have a property (under the 'other' tab)
called "AllowAutoCorrect". By default this is set to 'YES', so you
would set it to 'NO'.

Programmatically it would be something like:

Forms("FormName").Controls("ControlName").AllowAu toCorrect = False

Please forgive my ignorance. I am more family with web-related stuff
because I have been a web developer for 9 years. However, when it
comes to VBA, I am just a newbie. May I ask if this AllowAutoCorrect
is available in VBA for Access 2002?

Reason I ask is, I added the following codes,

Private Sub Last_Name_GotFocus()
Me.AllowAutoCorrect = False
End Sub

When I tabbed to the Last Name field, it bombed out saying that
AllowAutoCorrect is not a valid property.
The "Me" in your statement refers to the Active Form, not the Active
Control. Forms do not have an AllowAutoCorrect property, and, indeed, not
all Controls have one -- only controls "TextBox" and "ComboBox" into which
the user can type a value. I think if you will try

Me.Last_Name.AllowAutoCorrect = False

you will not have the problem.

However, just as an idle question: Since you want to disable AutoCorrect for
the Control whenever it has the Focus, and since you can't enter information
into the Control unless it has the Focus, it would appear you never want
AutoCorrect when entering information. If I am correct in my understanding,
why not simply set the Allow AutoCorrect property to "No" in design view?

Larry Linson
Microsoft Access MVP
Apr 16 '07 #4
On Apr 16, 9:27 am, "Larry Linson" <boun...@localhost.notwrote:
<sweetguy1o...@gmail.comwrote
>The field in your Form should have a property (under the 'other' tab)
>called "AllowAutoCorrect". By default this is set to 'YES', so you
>would set it to 'NO'.
>>
>Programmatically it would be something like:
>>
>Forms("FormName").Controls("ControlName").AllowAu toCorrect = False
>
Please forgive my ignorance. I am more family with web-related stuff
because I have been a web developer for 9 years. However, when it
comes to VBA, I am just a newbie. May I ask if this AllowAutoCorrect
is available in VBA for Access 2002?
>
Reason I ask is, I added the following codes,
>
Private Sub Last_Name_GotFocus()
Me.AllowAutoCorrect = False
End Sub
>
When I tabbed to the Last Name field, it bombed out saying that
AllowAutoCorrect is not a valid property.

The "Me" in your statement refers to the Active Form, not the Active
Control. Forms do not have an AllowAutoCorrect property, and, indeed, not
all Controls have one -- only controls "TextBox" and "ComboBox" into which
the user can type a value. I think if you will try

Me.Last_Name.AllowAutoCorrect = False

you will not have the problem.

However, just as an idle question: Since you want to disable AutoCorrect for
the Control whenever it has the Focus, and since you can't enter information
into the Control unless it has the Focus, it would appear you never want
AutoCorrect when entering information. If I am correct in my understanding,
why not simply set the Allow AutoCorrect property to "No" in design view?

Larry Linson
Microsoft Access MVP
Thank you very much for your response.

I just thought that Me is the equivalent of "this" in javascript.
That's why I thought I could do it on the field level.
I just looked at the design view again. Yes, I found that AutoCorrect
property.

I just took over the software from somebody else. I am not sure where
everything is.

Once again, thanks for your input

Apr 16 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ben | last post by:
I've got an asp page that populates a listbox with info from a db. The list box ends up being pretty big, so I want to be able to search it effectively. I like the method wherein the user types...
5
by: Barry | last post by:
Hello, I've recently noticed that someone can simply type in the URL to my javaScript, from my HTML source code, to the explorer location bar and an auto-save dialog pops up to let them save it...
1
by: Leif Wessman | last post by:
Why is a single space truncated in the following example? Leif alter table CURRENCY change column THOUSANDS_SEP THOUSANDS_SEP char(1) binary not null , type=MyISAM UPDATE CURRENCY SET...
0
by: Ian | last post by:
When you add a control to the web form designer in VS.NET, say a label called "InheritanceTestLabel", VS.NET automatically adds the following line to the code-behind. protected new...
2
by: John Holmes | last post by:
I saw a similar post that went unanswered about a month ago. I am annoyed by the auto-formatting that occurs when creating my form. I'll make changes to the code (HTML tab) and then view them in...
2
by: Joe Cool | last post by:
When I put a disk in my dvd drive, most of the time windows askes me how I want to process the files on the disk. Sometimes, it will automatically open a browser window showing the contents of the...
1
by: moi | last post by:
Hello, I have make a login form with an active directory membership. The trouble is that Internet Explorer may keep in memory the login/password of the user. Is there a way to disable it from the...
3
by: dasani | last post by:
Hello, I have a question about disabling auto-spell-checker function of some browsers, especially the current version of Safari. Although the function is useful in general, it's problematic for my...
2
by: richard.nigro | last post by:
When you double-click on a control in the designer window, it creates the 'default' event for that control. Is there any way to disable this functionality?
1
by: Paul Schwann | last post by:
Hi Group, I am using C# with .NET 2.0 and Visual Studio 2005. I have a GUI with a DataGridView (DGV) and a BindingSource for the data. The data are added programmatically, up to 5 rows per...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.