Field unsearchable

[Hylke]

I got two email address fields. Validated for a @ present, and no hard returns and no empty spaces. Both are set for entry in the Find mode. Rather plain.

Entering an existing email address into the Find mode, delivers a Not found. The others fields do act normal in Finds. The email address field is just one of many. The dbase has been operating since 1988 and I have never experienced this odd behaviour.

I tried with the validation switched off. No difference.

Any idea what I might have overlooked?

[Ocean West]

you need to quote "[email protected]" while performing a find because @ is a find operator. 

 

[Hylke]

Oh my, after all these years!!!!!

Thanks so much Ocean West.

I should include it in the script, so the user won't have to know.

Edited January 8, 2022 by Hylke