Solved

Autocorrect in Access 2003

Posted on 2004-10-20
9
404 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
ID: 12358476
"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
ID: 12358987
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
ID: 12359159
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
ID: 12359631
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 39

Expert Comment

by:stevbe
ID: 12360611
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
ID: 12361382
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
ID: 12361472
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
ID: 12361494
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
ID: 12366226
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 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

19 Experts available now in Live!

Get 1:1 Help Now