Limiting text length in free text field


New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
Please help

I am updating an outlook form. I have a field whose type is set to text and whose property is set to value. The field name is "sys" It is a free text field. I would like to to limit user entries to text of length 50 characters or less. So I am trying to use a validation formula and a validation message.

When I use this Len("sys")<=50

I get NO validation message whether I enter less than 50 characters or more than 50 characters


When I use the greater than sign: Len("sys")>=50

I get the validation message whether the user entered more than 50 characters or less than 50 characters

Question: What am I doing wrong and how can I limit entries to text of length 50 characters or less?
Similar threads
Thread starter Title Forum Replies Date
R Limiting length of saved attachment in VBA Outlook VBA and Custom Forms 2
D Limiting email notifications message Using Outlook 1
D Wishlist Limiting attendance at meetings Outlook Wishlist 1
R Limiting meeting attendees using VBA or an add-in Using Outlook 9
R Limiting Outlook Access to Inside Network Only Exchange Server Administration 1
J Limiting time range dislayed on calender - Outlook 2010 Using Outlook 1
J Autoreply email recieved from specific sender after deleting some text from body. Using Outlook 0
O Outlook tasks - Add text column with multiple lines Using Outlook 3
S Body text of Email from invite date/time Outlook VBA and Custom Forms 7
T Why does outlook 2010 convert only some forum notifications to plain text? Using Outlook 0
B VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 3
Jennifer Murphy Ctrl+Tab sometimes will not move through text a word at a time Using Outlook 1
B Add Prefix text to Subject Line Using Outlook 1
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
S Change VBA script to send HTML email instead of text Outlook VBA and Custom Forms 3
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
T Missing text in e-mail message after "(Please keep confidential)" Using Outlook 3
S Outlook to check for specific text Outlook VBA and Custom Forms 3
A Read and Write to Text File Outlook VBA and Custom Forms 1
J Program Checkbox that will activate a text box in a Outlook fallible form. Outlook VBA and Custom Forms 1
N How to remove signature formatting from Text in Word (accidentally taken from Outlook) Using Outlook 0
B Paste formatted text (bold, underlined and in quotes) Outlook VBA and Custom Forms 1
J Remove text to Clean Up Outlook VBA and Custom Forms 1
O Macro - paste as plain text Outlook VBA and Custom Forms 2
N Is there an Outlook tool to normalize text for entries that are in ALL CAPS? Using Outlook 2
e_a_g_l_e_p_i Is there a way to add something that is in the "Format Text" tab to the "basic Text" on the message tab Using Outlook 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
D Body text of email disappears when I scan an attachment from printer to email Using Outlook 1
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
RangerRick Text Extraction from forwarded messages external Exchange Server Administration 1
S Emails Configured As HTML But Sent As Plain Text Using Outlook 13
W Message Text Using Outlook 1
K Update subject based on text in body Outlook VBA and Custom Forms 3
C Transfer Outlook TextBox Text Into Email Body Outlook VBA and Custom Forms 2
J Marco in search of text in subject line Using Outlook 8
Tanja Östrand Outlook 2016 - Create Macro button to add text in Subject Outlook VBA and Custom Forms 1
M attached images not showing in text area Exchange Server Administration 0
Brostin Forward a mail to the address listed in the email text Outlook VBA and Custom Forms 1
P Can't see full text in From and Subject line Using Outlook 1
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
D Delete selected text from incoming emails Outlook VBA and Custom Forms 25
Diane Poremsky Outlook VBA: Use a Text File to Populate a ListBox New Articles 0
B Importing Text from Excel to Outlook 2013 Calender Using Outlook 0
B Import Excel Text into Outlook Calender Using Outlook 4
Diane Poremsky Create Task or Appointment and Insert Selected Text New Articles 0
n2b Accessing Plain Text Draft Without Outlook Using Outlook 3
sneaky30 convert text to date Outlook VBA and Custom Forms 1

Similar threads