Limiting text length in free text field

Status
Not open for further replies.
V

vincetaylor

Senior 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


Capture.JPG


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?
 
Status
Not open for further replies.
< Pull Outlook shared calendars items from Excel | Outlook Custom Form Scripting only working when clicking on "Run this form" >
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
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
T Replace Text in Email Subject Outlook VBA and Custom Forms 3
P Email and calendar entry text now shifts right about 3 tabs worth of space Using Outlook 1
M Folder names - rich text Using Outlook 6
E Replying to a plain text e-mail with HTML Using Outlook 2
H Finding text in open email Outlook VBA and Custom Forms 12
D Can't read some emails - text size too small. Using Outlook 2
AndyZ Contact Custom Form Tiny Text Outlook VBA and Custom Forms 3
D Delete selected text in outgoing email body Outlook VBA and Custom Forms 0
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
O Replace hard returns with soft returns on selected text and button to QAT Using Outlook 5
J Outlook 365 Emails showing as links and text only Using Outlook 4
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
J Text icon in Quick Access toolbar ? Using Outlook 2
S New Outlook Appointment - Select All Body Text and Change Font and Size Outlook VBA and Custom Forms 1
Z Copy specific email body text Outlook VBA and Custom Forms 0
L did MS ever add way to text via Outlook Using Outlook 5
B Outlook 365 Populate Outlook Task UDFs from a UDF text string Outlook VBA and Custom Forms 2
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1
BartH Add a string to the conditions in .Conditions.BodyOrSubject.Text Outlook VBA and Custom Forms 2
S HTML to Plain Text Macro - Help Outlook VBA and Custom Forms 1
S Unable to extract text from an Outlook email message Using Outlook 2
T Original email text not shown when replying or forwarding the email. Using Outlook 9
M Outlook, send to > mail recipient - results in plain text email Using Outlook 1
P Forwarding emails issue with special characters replacing text body 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
Z 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 10
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

Similar threads

Back
Top