Unbound text control

G

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.
 
F

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.
Click to expand...

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

Len([ctlMessage])<146 OR Is Null
 
G

George R

The corrected validation rule fixed the problem. Thank you!

fredg said:
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.
Click to expand...

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

Len([ctlMessage])<146 OR Is Null
Click to expand...
 
Top