Solved

Autocorrect in Access 2003

Posted on 2004-10-20
9
406 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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
 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

839 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