Seems like a simple and often-used function, but I need a calculation to restrict field entries to the most basic roman alphabetical characters.

Maybe I got a bit rusty on my functions, but I can't think of any function that this could be done with. Nor can I find anything here and elsewhere.

Any tips much appreciated!

Try using Filter() with a string containing your allowed characters.

I think you would have to use the 'Code' function. Separate the characters of the entry and filter them against the acceptable range of allowed Unicode characters.

Edit:

Yep, 'Filter' is a much easier way to do it. I was thinking back to when I did something similar, comparing ASCII characters when I was writing BASIC on Apple IIs.

Edited October 13, 201015 yr by Guest
missing a function I've never had to use

Thanks, I'll give it a go!