Autocorrect in Access 2003

"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

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.

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

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.

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

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.

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

Steve

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

https://www.experts-exchange.com/questions/21172204/Need-a-checkbox-that-can-lock-the-record-on-a-form.html

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