Unbound text control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
Back
Top