Difference in SelStart & SelLength in regular vs activeX text boxes

[kent]

I've needed to use ActiveX text boxes for some functionality that regular text boxes don't have, and I noticed with the ActiveX text boxes that when using functions like InStr() and Len() that the character locations don't match the locations that SelStart refers to. After some investigation, I found:

• For standard functions like InStr() and Len(), vbnewlines are counted as 2 characters long
• For regular text boxes, vbnewlines are counted as 2 characters long by SelStart and SelLength
• For activeX text boxes, vbnewlines are counted as 1 character long by SelStart and SelLength

Are there any settings for the activeX text box that can set vbNewLine to be counted as 2 characters by SelStart and SelLength so I don't have to do calculations in VBA to correctly calculate positions in long multiline documents?

[CJ_London]

It’s because in your first two examples a return is chr(10) + chr(13) whilst some apps and active x just use chr(10)

so no setting you can use to change that

depends on what you are trying to do but to get comparable lengths you could use the replace function to replace chr(13) with a zls - but repeat, depends on what you are trying to do

[Micron]

When both are required, AFAIK the order matters, and I think the order is Chr(13) followed by Chr(10)?

[CJ_London]

you are correct

?asc(left(vbcrlf,1))
13