Search results

Thanks for all your help and I'm all sorted with this now!!

Hi Doc This does invalidate the whole string which is what I wanted to achieve. The source of the strings I want to invalidate are various, but primarily to do with bespoke import functions. Carriage returns (etc) can clearly be allowed if necessary by omitting the chr$(10) and (13). Thanks...

Here I'm trying to send the post that went missing ... Setting the ValidationRule to the following seems to work: Not ((Like "*" & chr$(1) & "*") OR (Like "*" & chr$(2) & "*") OR ... OR (Like "*" & chr$(31) & "*") OR (Like "*" & chr$(127) & "*")) Notes: a) Fortunately the string in its...

I made a follow up post (before yours?) with more details, but I got a message saying the moderator had to check it before the post was finalised. I'll wait to see it gets in before replying. Again, thanks. My wife has looked after me for so many years that I'm pleased (in a way) that I can...

Setting the ValidationRule to the following seems to work: Not ((Like "*" & chr$(1) & "*") OR (Like "*" & chr$(2) & "*") OR ... OR (Like "*" & chr$(31) & "*") OR (Like "*" & chr$(127) & "*")) Notes: a) Fortunately the string in its entirety is less than 2048 characters so fits! b) If chr$(0)...

Thanks Doc for your reply. I would exclude them. Sometimes I want to be absolutely sure that there are no control characters in a text or memo field. Spurred on by your reply I'm experimenting but unable to finish the experiment as I'm going to and fro between hospital appointments for my...

Can one use field validation to exclude control characters (ie Chr(0-31) and chr(127)) from text fields? Or by another built in mechanism (ie, not by using VBA)? Thanks!! New member, David