Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

Autocorrect in Access 2003

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
kkamm
Asked:
kkamm
  • 5
  • 4
1 Solution
 
stevbeCommented:
"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
 
kkammAuthor Commented:
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
 
stevbeCommented:
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
kkammAuthor Commented:
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
 
stevbeCommented:
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
 
kkammAuthor Commented:
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
 
stevbeCommented:
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
 
stevbeCommented:
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
 
kkammAuthor Commented:
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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now