Unbound text control

[George R]

How can I limit the length of an unbound text field? I tried unsuccessfully
to use a validation rule:
="Len([ctlMessage])<146 OR Is Null"
This expression rejects all entries except the unchanged default entry.
Thanks for you assistance.

 

[KARL DEWEY]

Try setting the input mask.

 

[fredg]

How can I limit the length of an unbound text field? I tried unsuccessfully
to use a validation rule:
="Len([ctlMessage])<146 OR Is Null"
This expression rejects all entries except the unchanged default entry.
Thanks for you assistance.

You have incorrectly written the validation rule.
No = nor quotes needed.

Len([ctlMessage])<146 OR Is Null

 

[George R]

The corrected validation rule fixed the problem. Thank you!

How can I limit the length of an unbound text field? I tried unsuccessfully
to use a validation rule:
="Len([ctlMessage])<146 OR Is Null"
This expression rejects all entries except the unchanged default entry.
Thanks for you assistance.

You have incorrectly written the validation rule.
No = nor quotes needed.

Len([ctlMessage])<146 OR Is Null