Solved How to setup conditional formatting on a form

[Number11]

I am looking for a way to have the form highlight any names that greater than in characters

First Name <20
Surname <30

any pointers please?

 

[Eugene-LS]

Use Len() function

 

[Cotswold]

I'll just add that if you haven't saved the Fields in the Table using Trim() or by some other method, then Len() will not do that for you

XX = "ASDFGH" + Space(6) So, Len(XX) will give you 12, not maybe the 6 it looks like.

 

[Number11]

Use Len() function

Thanks that is working fine now