how to ignore HTLM tags when getting a length of a memo field

[djapigo]

Hello,

After searching through the archives and not finding something resembling my problem, I'm hoping someone can help me. Excel is my world, but Access, not so much...

I have memo field in a form that we are now limiting the number of characters to 350.

I found this code somewhere that works brilliantly.

Please Login or Register  to view this content.

CharCountMemo1 is a lable and Memo1 is my memo field.

Like I said, it works great, however, because it's a memo field (and I would like to keep it as is), when computing the Len of Memo1, it's also including the HTLM tags (<ul>, <li>, etc.) to the length.

Is there a way to "ignore" these tags to get the actual character count which I want to limit to 350 only?

Hope this is clear enough.

Thank you,
Dennis

PS I haven't tried yet, but is there also a way to incorporate a "condition formatting" feature that fills the memo field RED if it is currently over 350 characters. You see, the character limit is a new feature that we are trying to put in an existing working database. I want the obnoxious RED to show the user that they have something to fix.

[davegugg]

I would have suggested using the Replace() function with a wildcard, but apparently you can't use a wildcard with the replace function. This function will strip out all the html tags from a string. Put it inside your LEN() functions in lines two and three (or assign a variable for efficiency).

Please Login or Register  to view this content.

[djapigo]

Hi davegugg,

The code seems to be working great! I just have to tweak it a little bit to include if strInput is "blank".

I'll let you know if I find other problems with it.

In the meantime, thank you so much for guiding me to the right direction!

Dennis

[djapigo]

Hi davegugg,

Here is what I added to meet my conditions... blank entry, carriage return and blank spaces

Please Login or Register  to view this content.

Thank you so much for your code... it set me up perfectly... project complete!

Dennis