Skip to main content
Question

rich text field max characters size

  • Sep 10, 2018 10:40 PM UTC
  • 0 replies
  • 100 views

We have a rich text field that is configured to be 4000 characters max. When I put a 3721 character field (with spaces) and it gives me an error when I try to save the record. Is there a formula to determine the "real" number of characters that can be entered?
This topic has been closed for replies.

  • Observing
  • Sep 10, 2018 10:48 PM UTC
Length([Rich Text Field]) will give you the actual number of characters detected.

It could be detecting hidden characters or spaces from excel, as a guess.

The Rich text field is probably counting all the formatting fields such as <b> for bold etc.  I assume that you have a 4000 character limit as you are feeding data to another system with limited field size of 4,000 characters.  The number of characters will be depend on the amount of formatting that you do in the Rich Text field.

I suggest that you put the formula Slider suggested above on the form so the users can see how close they are to the limit.

  • Author
  • Qrew Corporal
  • Sep 10, 2018 11:08 PM UTC
Thanks, great suggestion