SelStart not accounting from spaces?

[tylerg11]

Hi All,



So I have a textbox in the header of one of my forms. For it's On Change event I have it filtering the form based on whatever is entered in the textbox. This works great. However, after the filter is re-applied after each "change", I have SelStart code to place the cursor back in the textbox. Problem is that SelStart does not seem to be accounting for any spaces in the textbox, and continues to place the cursor after the last character - not space - in the textbox. Here's the code:

    strLastName = Nz(Me.txtLastName.Text, "")
    
    Me.Filter = "CONTACT_LASTNAME like '%" & strLastName & "%'"
    
    Me.FilterOn = True
    
    Me.txtLastName.SelStart = Len(strLastName) + 1

For example, if I entered "An ", the Len() will return a 3, but when it goes to place the cursor back in the textbox, it basically seems to remove that trailing space. Therefore, the user is not allowed to insert spaces.

Any ideas??

Thanks!

[June7]

Appears to be the nature of textbox to drop trailing spaces. My testing with AfterUpdate event shows the Len results in 2 instead of 3. The space is dropped immediately and not included in the Len count. Testing Change event shows that the first time I enter "An " characters into box the Len count is 0 after each character. If I repeat "An " the count is 2. I have to null the box and the count will be 0 again. Not understanding this behavior and can't reproduce your results. Sorry.


Don't really need the Nz function, just concatenate an empty string.

strLastName = Me.txtLastName & ""

This is code in Access VBA? The default property of data controls is Value and is assumed if not specified. Text appears to produce the same result, just not necessary. I would have used the * wildcard but if % is working, fine.

[help_me_with_access]

dropping whitespace from values is a default behavior in access. as far as I know, all whitespace that appears after the last byte in any input is truncated.

but in all honesty, that seems to be decent behavior to me. i've never seen this question asked before, actually.