Solved

Autocorrect in Access 2003

Posted on 2004-10-20
9
403 Views
Last Modified: 2012-08-14
I was wondering...

Microsoft Word allows for a multi-line autocorrect from a single entry. I would prefer the same functionality for my memo fields in access.

Also, I've noticed that autocorrect only works in the first 255 characters of a memo field. Is there a way around this? I really need a longer autocorrect option, even if it has to be 2-3 words that i type to get the final result, I need 500+ characters of space.

Soo..... what are my options?
0
Comment
Question by:kkamm
  • 5
  • 4
9 Comments
 
LVL 39

Expert Comment

by:stevbe
Comment Utility
"Microsoft Word allows for a multi-line autocorrect from a single entry"
I am not sure what you mean by this.

"Also, I've noticed that autocorrect only works in the first 255 characters of a memo field."
If you are experiencing this on a form then delete the control you have now and drag the memo field from the Field List onto the form, Access sometimes gets confused if you create the textbox first and then bind it to a memo field.

Steve
0
 
LVL 1

Author Comment

by:kkamm
Comment Utility
What I mean by a multiline is this:


I have an autocorrect "macro," nv3. If I type nv3 in MS Word, it puts the following

Physical Exam: General:
VITAL SIGNS as noted
HEENT: Head: Atroumatic......

etc.


Now, access wont even TOUCH that autocorrect.

Also, I just made a dummy db1, with a table with only an autonumber and a memo field, made a form for the table, and tried to use the autocorrect features. It would not work.

Is this a limitation of Microsoft access to not use autocorrect if it will push the character limit past 255, even if it is a memo field, without such limitations. Understand that my autocorrect fields are 200-220 characters each, and I need to string 2-3 of them together. Maybe it would be better if I just added a set of buttons across the top of my memo field which would dump the text in. Could you show me that as an example; namely, tying a button to a memo field that when clicked, would dump the text in at the end of what was already in the field, NOT replace what was already in there.
0
 
LVL 39

Expert Comment

by:stevbe
Comment Utility
Sorry, I was completely misunderstanding you issue, I was talking about spell check, I did test a bit and I have no solution but did verify that AutoCorrect works like junk :-(

Steve
0
 
LVL 1

Author Comment

by:kkamm
Comment Utility
Okay, so autocorrect in Access is junk (sad to see that with all the MSOffice integrations, they gave all the programs different engines for autocorrect).

Any suggestions on making a button that dumps text in at the end of a memo field, without deleting whats currently in there? Maybe even a right click menu in the field that you can select the text block from.

Anything would be great. I'm kinda stumped here.
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 39

Expert Comment

by:stevbe
Comment Utility
You could make your own autocorrect and trigger it in the after_update event of the textbox.
To make it robust I would sugest that you store the values to be Corrected and the Correct values (much like Auto Correct Settings dialog looks like) in a table. If you only have a few and don't mind hardcoding them ...

A side not on memo fields ... they are one of the biggest causes of database corruption if there are controls bound directly to them. I use an unbound textbox and load the memo field contents in the form's curent event and then apply the value back to the memo field in the afterupdate event.


Private Sub txtMemo_AfterUpdate()
    Me.txtMemo.Value = Replace(Me.txtMemo.Value, "nv1", "My Notes.")
    Me.txtMemo.Value = Replace(Me.txtMemo.Value, "nv2", "My" & vbCrLf & "Mulit Line" & vbCrLf & "Notes.")
End Sub

the vbCrLf forces a new line in the actual text so nv2 will be replaced with ...l

My
Multi Line
Notes.

Steve
0
 
LVL 1

Author Comment

by:kkamm
Comment Utility
Write out a code snippet explaining how you use the unbound text box, and you got yourself some points. These fields could EASILY be 1000 characters long, so I cannot afford to leave a potential corruption in place.

Thanks for all your help; when the db goes down tonight, I will test this and if it works, you get the crown.
0
 
LVL 39

Accepted Solution

by:
stevbe earned 250 total points
Comment Utility
Private Form_Current()
    Me.txtMemo.Value = Me!Memo.Value
End Sub

Private Sub txtMemo_AfterUpdate()
    Me.txtMemo.Value = Replace(Me.txtMemo.Value, "nv1", "My Notes.")
    Me.txtMemo.Value = Replace(Me.txtMemo.Value, "nv2", "My" & vbCrLf & "Mulit Line" & vbCrLf & "Notes.")
    Me!Memo.Value = Me.txtMemo.Value
End Sub
0
 
LVL 39

Expert Comment

by:stevbe
Comment Utility
Memo is the Field name of the memo field as opposed to txtMemo which is the textbox you want to display / edit from.

Steve
0
 
LVL 1

Author Comment

by:kkamm
Comment Utility
Thanks! It worked Great!

I had to send a memo out to people to basically leave the field and re-enter it for the replace function to take hold (the afterupdate doesnt occur mid-stride like autocorrect does), but otherwise, its a winner. Thanks for your help.

Now if only you could help me on this one as well...

http://www.experts-exchange.com/Databases/MS_Access/Q_21172204.html

thats going for 500 points if you can figure it out ;)
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now