Recent content by dgreen

The below code works when I have a record with an Email_Address value. It fails when the value is null / blank. I've tried variations of If Not IsNull, IsBlank, etc.... Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:-...

Dust in the wind.

So this doesn't work. Did I misinterprete what you recommended I test? Fails to compile on .setfocus (invalid or unqualified reference) Public Function SpellChecker(strText As String) As Boolean On Error GoTo Err_SpellChecker If Trim(strText & " ") <> "" Then 'Handles...

So clear the value, then the delete shows up.

Is there a way to delete the value in the field from the Spell Checker form? Let's say my spelling is checking multiple fields and I get to this result. None of the suggestions are right, I'd like to just delete that word, and continue to spell check the remainder of the fields. There isn't...

I don't quite understand what this means.

@Micron Thank you for your persistence. Tmrw, I'm going to continue to troubleshoot and see if this fixes the issue with the base database. I hope this was the root cause that triggered the request for support.

It's working.

I'm down to a main form with primary key, last and first name and one subform with a text field. Only one field on the subform doing spell checking. I pulled most of the code off the forms. Maybe I'm down to a small enough subset to troubleshoot? In the attached, open Contacts and then move...

Continuing to reduce.

I'm going to keep trying to reduce the code down to try and get to the essentials. Compact on close was checked. I unchecked for the next update. Removed the Navigation form, most of the fields on the Contacts form. Removed all but one subform (since having zero subforms stops the issue...

Looks like we're talking past each other. I think Ive only coded the spelling to happen on specific text fields and definitely not on the organization field which is a combo box.

The Isblank is a public function. It appears that having a no record value on a sub data sheet triggers it. Nothing to do with spelling. If try, why is the question we're trying to answer. The position title field is getting spelled checked because people would be typing in their own values...

A great rhetorical question. When you figure out why it's happening we're all ears.

I took the complete class module (FindASYouTypeCombo) from v11 and put it into the database that we're troubleshooting on the other thread. 13 Type mismatch when I allow the following to run on form load. faytManagerNameID.InitalizeFilterCombo Me.Manager_Name_ID, , anywhereinstring, True I...