Caret overlapping text when typing and moving

[jmaty23]

I have an Access form that is tied to a recordset. When I Set Focus on 1 text box in particular, I move the caret with the keyboard arrows left-right, and the caret moves and flashes on top of the text characters, basically overlaps the character. When I then try to delete or edit the text, it moves the caret by itself to a different location in the text box and starts adding the text to that location. When I finally get the text how I want it, I set focus on another control, and it occasionally deletes random characters in the text box.

The only way I have been able to work around this is to copy and paste the current text into Notepad, edit it there, and then paste it back into the text box.

Anyone ever had this happen or have a solution?

 

[JHB]

Anyone ever had this happen ...?

Could you post/show a printscreen of the problem?

 

[jmaty23]

I created a mpeg video of the issue.

I uploaded it to my Google Drive. Here is the link.

https://drive.google.com/file/d/0B9PKnB_WXZhOZUxIVGRGdFhGN1k/edit?usp=sharing

 

[BlueIshDan]

What is your font, size and if you know how could you pour it into a byte array and display a chunk of the results.

 

[jmaty23]

Some background on the form and database. It is a split access database with the back-end located on a file server. The database has at most 5 people using it at any given time. The field type is MEMO.

If it matters, the back-end database is an .mdb file and the front-end is .accdb

I have attached a screen shot of the property sheet for the text field.

 

[BlueIshDan]

Could you tell me the result of this please

This will return the bytes of your value in your text box if you modify it to suit your form.

Private Sub Command0_Click()
    Dim var_byte As Variant
    Dim arr_bytes() As Byte: arr_bytes = txtBox.Value
    Dim str_bytes As String
    
    For Each var_byte In arr_bytes
        str_bytes = str_bytes & CStr(var_byte) & " "
    Next
    
    MsgBox str_bytes, vbOKOnly, "Bytes Conversion"
End Sub

 

[vbaInet]

Try changing the Text Format from Plain Text to Rich Text.

 

[jmaty23]

Here is the result from the same text in the video.

49 0 46 0 9 0 80 0 108 0 97 0 99 0 101 0 32 0 116 0 104 0 101 0 32 0 109 0 97 0 105 0 110 0 32 0 98 0 114 0 101 0 97 0 107 0 101 0 114 0 32 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 28 32 79 0 70 0 70 0 29 32 32 0 112 0 111 0 115 0 105 0 116 0 105 0 111 0 110 0 32 0 97 0 110 0 100 0 32 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 32 0 108 0 111 0 99 0 107 0 111 0 117 0 116 0 47 0 116 0 97 0 103 0 111 0 117 0 116 0 32 0 100 0 101 0 118 0 105 0 99 0 101 0 46 0 32 0 79 0 112 0 101 0 110 0 32 0 116 0 104 0 101 0 32 0 114 0 101 0 109 0 111 0 116 0 101 0 32 0 99 0 111 0 110 0 116 0 114 0 111 0 108 0 32 0 112 0 97 0 110 0 101 0 108 0 32 0 108 0 111 0 99 0 97 0 116 0 101 0 100 0 32 0 111 0 110 0 32 0 116 0 104 0 101 0 32 0 80 0 75 0 32 0 97 0 110 0 100 0 32 0 117 0 115 0 101 0 32 0 97 0 32 0 109 0 117 0 108 0 116 0 105 0 45 0 109 0 101 0 116 0 101 0 114 0 32 0 116 0 111 0 32 0 114 0 101 0 102 0 101 0 114 0 101 0 110 0 99 0 101 0 32 0 118 0 111 0 108 0 116 0 97 0 103 0 101 0 32 0 111 0 110 0 32 0 116 0 104 0 101 0 32 0 105 0 110 0 99 0 111 0 109 0 105 0 110 0 103 0 32 0 116 0 101 0 114 0 109 0 105 0 110 0 97 0 108 0 115 0 44 0 32 0 105 0 102 0 32 0 110 0 111 0 32 0 118 0 111 0 108 0 116 0 97 0 103 0 101 0 32 0 105 0 115 0 32 0 112 0 114 0 101 0 115 0 101 0 110 0 116 0 32 0 116 0 104 0 101 0 110 0 32 0 116 0 104 0 105 0 115 0 32 0 109 0 101 0 97 0 110 0 115 0 32 0 116 0 104 0 97 0 116 0 32 0 116 0 104 0 101 0 32 0 101 0 108 0 101 0 99 0 116 0 114 0 105 0 99 0 97 0 108 0 32 0 112 0 111 0 114 0 116 0 105 0 111 0 110 0 32 0 111 0 102 0 32 0 116 0 104 0 101 0 32 0 117 0 110 0 105 0 116 0 32 0 105 0 115 0 32 0 105 0 115 0 111 0 108 0 97 0 116 0 101 0 100 0 46 0 13 0 10 0 50 0 46 0 9 0 80 0 108 0 97 0 99 0 101 0 32 0 116 0 104 0 101 0 32 0 104 0 111 0 116 0 32 0 119 0 97 0 116 0 101 0 114 0 32 0 102 0 101 0 101 0 100 0 32 0 97 0 110 0 100 0 32 0 99 0 105 0 116 0 121 0 32 0 119 0 97 0 116 0 101 0 114 0 32 0 102 0 101 0 101 0 100 0 32 0 98 0 97 0 108 0 108 0 32 0 118 0 97 0 108 0 118 0 101 0 115 0 32 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 28 32 67 0 76 0 79 0 83 0 69 0 68 0 29 32 32 0 112 0 111 0 115 0 105 0 116 0 105 0 111 0 110 0 32 0 97 0 110 0 100 0 32 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 32 0 108 0 111 0 99 0 107 0 111 0 117 0 116 0 47 0 116 0 97 0 103 0 111 0 117 0 116 0 32 0 100 0 101 0 118 0 105 0 99 0 101 0 46 0 32 0 76 0 111 0 99 0 97 0 116 0 101 0 32 0 116 0 104 0 101 0 32 0 189 0 32 0 28 32 98 0 97 0 108 0 108 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 111 0 110 0 32 0 116 0 104 0 101 0 32 0 111 0 117 0 116 0 112 0 117 0 116 0 32 0 115 0 105 0 100 0 101 0 32 0 111 0 102 0 32 0 116 0 104 0 101 0 32 0 50 0 32 0 189 0 29 32 32 0 104 0 111 0 116 0 32 0 119 0 97 0 116 0 101 0 114 0 32 0 103 0 97 0 116 0 101 0 32 0 118 0 97 0 108 0 118 0 101 0 46 0 32 0 73 0 110 0 115 0 117 0 114 0 101 0 32 0 116 0 104 0 97 0 116 0 32 0 116 0 104 0 101 0 32 0 98 0 97 0 108 0 108 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 105 0 115 0 32 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 28 32 99 0 108 0 111 0 115 0 101 0 100 0 29 32 32 0 112 0 111 0 115 0 105 0 116 0 105 0 111 0 110 0 32 0 97 0 110 0 100 0 32 0 114 0 101 0 109 0 111 0 118 0 101 0 32 0 116 0 104 0 101 0 32 0 99 0 111 0 114 0 114 0 101 0 115 0 112 0 111 0 110 0 100 0 105 0 110 0 103 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 112 0 108 0 117 0 103 0 46 0 32 0 83 0 108 0 111 0 119 0 108 0 121 0 32 0 111 0 112 0 101 0 110 0 32 0 116 0 104 0 101 0 32 0 189 0 29 32 32 0 98 0 97 0 108 0 108 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 119 0 104 0 105 0 108 0 101 0 32 0 102 0 111 0 108 0 108 0 111 0 119 0 105 0 110 0 103 0 32 0 112 0 114 0 111 0 112 0 101 0 114 0 32 0 80 0 46 0 80 0 46 0 69 0 46 0 32 0 115 0 116 0 97 0 110 0 100 0 97 0 114 0 100 0 115 0 32 0 115 0 116 0 97 0 116 0 101 0 100 0 32 0 119 0 105 0 116 0 104 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 76 0 46 0 79 0 46 0 84 0 46 0 79 0 32 0 103 0 117 0 105 0 100 0 101 0 108 0 105 0 110 0 101 0 115 0 32 0 111 0 102 0 32 0 116 0 104 0 105 0 115 0 32 0 97 0 115 0 115 0 101 0 116 0 46 0 32 0 73 0 102 0 32 0 119 0 97 0 116 0 101 0 114 0 32 0 100 0 111 0 101 0 115 0 32 0 110 0 111 0 116 0 32 0 99 0 111 0 110 0 116 0 105 0 110 0 117 0 101 0 32 0 116 0 111 0 32 0 100 0 114 0 97 0 105 0 110 0 32 0 102 0 111 0 114 0 32 0 109 0 111 0 114 0 101 0 32 0 116 0 104 0 97 0 110 0 32 0 51 0 48 0 32 0 115 0 101 0 99 0 111 0 110 0 100 0 115 0 32 0 116 0 104 0 101 0 110 0 32 0 116 0 104 0 105 0 115 0 32 0 109 0 101 0 97 0 110 0 115 0 32 0 116 0 104 0 97 0 116 0 32 0 121 0 111 0 117 0 32 0 99 0 97 0 110 0 32 0 99 0 108 0 111 0 115 0 101 0 32 0 116 0 104 0 101 0 32 0 189 0 29 32 32 0 98 0 97 0 108 0 108 0 32 0 118 0 97 0 108 0 118 0 101 0 44 0 32 0 114 0 101 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 32 0 116 0 104 0 101 0 32 0 99 0 111 0 114 0 114 0 101 0 115 0 112 0 111 0 110 0 100 0 105 0 110 0 103 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 112 0 108 0 117 0 103 0 44 0 32 0 99 0 108 0 111 0 115 0 101 0 32 0 116 0 104 0 101 0 32 0 50 0 32 0 189 0 29 32 32 0 104 0 111 0 116 0 32 0 119 0 97 0 116 0 101 0 114 0 32 0 103 0 97 0 116 0 101 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 97 0 110 0 100 0 32 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 32 0 108 0 111 0 99 0 107 0 111 0 117 0 116 0 47 0 116 0 97 0 103 0 111 0 117 0 116 0 32 0 100 0 101 0 118 0 105 0 99 0 101 0 46 0 32 0 65 0 116 0 32 0 116 0 104 0 105 0 115 0 32 0 112 0 111 0 105 0 110 0 116 0 32 0 116 0 104 0 101 0 32 0 119 0 97 0 116 0 101 0 114 0 32 0 112 0 111 0 114 0 116 0 105 0 111 0 110 0 32 0 111 0 102 0 32 0 116 0 104 0 101 0 32 0 117 0 110 0 105 0 116 0 32 0 105 0 115 0 32 0 105 0 115 0 111 0 108 0 97 0 116 0 101 0 100 0 46 0 13 0 10 0 51 0 46 0 9 0 80 0 108 0 97 0 99 0 101 0 32 0 116 0 104 0 101 0 32 0 53 0 29 32 32 0 109 0 97 0 105 0 110 0 32 0 115 0 116 0 101 0 97 0 109 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 28 32 67 0 76 0 79 0 83 0 69 0 68 0 29 32 32 0 112 0 111 0 115 0 105 0 116 0 105 0 111 0 110 0 32 0 97 0 110 0 100 0 32 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 32 0 108 0 111 0 99 0 107 0 111 0 117 0 116 0 47 0 116 0 97 0 103 0 111 0 117 0 116 0 32 0 100 0 101 0 118 0 105 0 99 0 101 0 46 0 32 0 76 0 111 0 99 0 97 0 116 0 101 0 32 0 116 0 104 0 101 0 32 0 190 0 29 32 32 0 103 0 97 0 116 0 101 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 108 0 111 0 99 0 97 0 116 0 101 0 100 0 32 0 111 0 110 0 32 0 116 0 104 0 101 0 32 0 111 0 117 0 116 0 108 0 101 0 116 0 32 0 115 0 105 0 100 0 101 0 32 0 111 0 102 0 32 0 116 0 104 0 101 0 32 0 109 0 97 0 105 0 110 0 32 0 115 0 116 0 101 0 97 0 109 0 32 0 103 0 97 0 116 0 101 0 32 0 118 0 97 0 108 0 118 0 101 0 46 0 32 0 73 0 110 0 115 0 117 0 114 0 101 0 32 0 116 0 104 0 97 0 116 0 32 0 116 0 104 0 101 0 32 0 103 0 97 0 116 0 101 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 105 0 115 0 32 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 28 32 99 0 108 0 111 0 115 0 101 0 100 0 29 32 32 0 112 0 111 0 115 0 105 0 116 0 105 0 111 0 110 0 32 0 97 0 110 0 100 0 32 0 114 0 101 0 109 0 111 0 118 0 101 0 32 0 116 0 104 0 101 0 32 0 99 0 111 0 114 0 114 0 101 0 115 0 112 0 111 0 110 0 100 0 105 0 110 0 103 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 112 0 108 0 117 0 103 0 46 0 32 0 83 0 108 0 111 0 119 0 108 0 121 0 32 0 111 0 112 0 101 0 110 0 32 0 116 0 104 0 101 0 32 0 190 0 29 32 32 0 103 0 97 0 116 0 101 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 119 0 104 0 105 0 108 0 101 0 32 0 102 0 111 0 108 0 108 0 111 0 119 0 105 0 110 0 103 0 32 0 112 0 114 0 111 0 112 0 101 0 114 0 32 0 80 0 46 0 80 0 46 0 69 0 46 0 32 0 115 0 116 0 97 0 110 0 100 0 97 0 114 0 100 0 115 0 32 0 115 0 116 0 97 0 116 0 101 0 100 0 32 0 119 0 105 0 116 0 104 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 76 0 46 0 79 0 46 0 84 0 46 0 79 0 32 0 103 0 117 0 105 0 100 0 101 0 108 0 105 0 110 0 101 0 115 0 32 0 111 0 102 0 32 0 116 0 104 0 105 0 115 0 32 0 97 0 115 0 115 0 101 0 116 0 46 0 32 0 73 0 102 0 32 0 110 0 111 0 32 0 115 0 116 0 101 0 97 0 109 0 32 0 105 0 115 0 32 0 112 0 114 0 101 0 115 0 101 0 110 0 116 0 32 0 116 0 104 0 101 0 110 0 32 0 116 0 104 0 105 0 115 0 32 0 109 0 101 0 97 0 110 0 115 0 32 0 116 0 104 0 97 0 116 0 32 0 116 0 104 0 101 0 32 0 115 0 116 0 101 0 97 0 109 0 32 0 112 0 111 0 114 0 116 0 105 0 111 0 110 0 32 0 111 0 102 0 32 0 116 0 104 0 105 0 115 0 32 0 117 0 110 0 105 0 116 0 32 0 105 0 115 0 32 0 105 0 115 0 111 0 108 0 97 0 116 0 101 0 100 0 46 0 13 0 10 0 52 0 46 0 9 0 80 0 108 0 97 0 99 0 101 0 32 0 116 0 104 0 101 0 32 0 189 0 29 32 32 0 112 0 110 0 101 0 117 0 109 0 97 0 116 0 105 0 99 0 32 0 98 0 97 0 108 0 108 0 32 0 118 0 97 0 108 0 118 0 101 0 32 0 105 0 110 0 32 0 116 0 104 0 101 0 32 0 111 0 102 0 102 0 32 0 112 0 111 0 115 0 105 0 116 0 105 0 111 0 110 0 32 0 97 0 110 0 100 0 32 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 32 0 108 0 111 0 99 0 107 0 111 0 117 0 116 0 47 0 116 0 97 0 103 0 111 0 117 0 116 0 32 0 100 0 101 0 118 0 105 0 99 0 101 0 46 0 32 0 79 0 112 0 101 0 110 0 32 0 116 0 104 0 101 0 32 0 100 0 101 0 45 0 119 0 97 0 116 0 101 0 114 0 105 0 110 0 103 0 32 0 110 0 117 0 116 0 32 0 111 0 110 0 32 0 101 0 32 0 98 0 111 0 116 0 116 0 111 0 109 0 32 0 116 0 104 0 101 0 32 0 99 0 111 0 114 0 114 0 101 0 115 0 112 0 111 0 110 0 100 0 105 0 110 0 103 0 32 0 114 0 101 0 103 0 117 0 108 0 97 0 116 0 111 0 114 0 32 0 117 0 110 0 116 0 105 0 108 0 32 0 116 0 104 0 101 0 32 0 105 0 110 0 115 0 116 0 97 0 108 0 108 0 101 0 100 0 32 0 103 0 97 0 117 0 103 0 101 0 32 0 114 0 101 0 97 0 100 0 115 0 32 0 122 0 101 0 114 0 111 0 32 0 112 0 115 0 105 0 32 0 97 0 110 0 100 0 32 0 116 0 104 0 101 0 110 0 32 0 99 0 108 0 111 0 115 0 101 0 32 0 116 0 104 0 101 0 32 0 110 0 117 0 116 0 44 0 32 0 105 0 102 0 32 0 116 0 104 0 101 0 32 0 103 0 97 0 117 0 103 0 101 0 32 0 104 0 111 0 108 0 100 0 115 0 32 0 97 0 32 0 122 0 101 0 114 0 111 0 32 0 112 0 115 0 105 0 32 0 114 0 101 0 97 0 100 0 105 0 110 0 103 0 32 0 116 0 104 0 101 0 110 0 32 0 116 0 104 0 105 0 115 0 32 0 109 0 101 0 97 0 110 0 115 0 32 0 116 0 104 0 97 0 116 0 32 0 116 0 104 0 101 0 32 0 112 0 110 0 101 0 117 0 109 0 97 0 116 0 105 0 99 0 32 0 112 0 111 0 114 0 116 0 105 0 111 0 110 0 32 0 111 0 102 0 32 0 116 0 104 0 101 0 32 0 117 0 110 0 105 0 116 0 32 0 105 0 115 0 32 0 105 0 115 0 111 0 108 0 97 0 116 0 101 0 100 0 32 0 97 0 110 0 100 0 32 0 116 0 104 0 101 0 32 0 109 0 97 0 99 0 104 0 105 0 110 0 101 0 32 0 105 0 115 0 32 0 102 0 117 0 108 0 108 0 121 0 32 0 100 0 101 0 45 0 101 0 110 0 101 0 114 0 103 0 105 0 122 0 101 0 100 0 46 0

 

[jmaty23]

Do I need to change the text format to "Rich Text" in the table before I change it on the control?

 

[BlueIshDan]

Bytes look fine. Try doing as vbaInet says and changing the text format to "Rich Text" in your textbox' properties.

 

[jmaty23]

Do I need to change the text format to "Rich Text" in the table before I change it on the control?

 

[vbaInet]

You don't need clarity on this, try all the ways you see necessary. Obviously doing it on a copy.

 

[jmaty23]

I would like to be sure that the text isn't permanently changed after I make the text format "Rich Text". This is something I haven't done before.

 

[vbaInet]

But BlueIshDan had already confirmed where it could be changed, i.e. in the control properties. So try both ways.

 

[jmaty23]

I changed it in the text box properties only and it seams to have solved the issue.

Thank you for the assistance.

 

[vbaInet]

Good to hear!

Don't be afraid to test anything, it's the best way to learn. Even if you do change something, do it on a backup copy and if something goes wrong, get another copy.